pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nid <mk_spam@comcast.net>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: Where to start for performance problem?
Date: Mon, 24 Nov 2003 21:05:56 -0600
Message-ID: <2b8e01c3b301$0bc2f090$0201a8c0@game> (raw)
References: <2b1f01c3b2d6$c403ba70$0201a8c0@game>
	<3FC2ACCF.2030303@familyhealth.com.au>

I've been digging around in the code and found where we are executing the
VACUUM command.  VACUUM ANALYZE is executed every 15 minutes.  We haven't
tried VACUUM FULL ANALYZE.  I think I read that using FULL is a good idea
once a day or something.  Just doing a VACUUM ANALYZE doesn't seem to be
preventing our problem.  Thank you for the responses.

nid

----- Original Message ----- 
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "MK Spam" <mk_spam@comcast.net>
Cc: <pgsql-performance@postgresql.org>
Sent: Monday, November 24, 2003 7:13 PM
Subject: Re: [PERFORM] Where to start for performance problem?


> > The archives of this list provides many ideas for improving performance,
> > but the problem we are having is gradually degrading performance ending
> > in postgres shutting down.  So it's not a matter of optimizing a complex
> > query to take 5 seconds instead of 60 seconds.  >From what I can tell we
> > are using the VACUUM command on a schedule but it doesn't seem to
> > prevent the database from becoming "congested" as we refer to it.  :]
>
> Our busy website has a cronjob that runs VACUUM ANALYZE once an hour
> (vacuumdb -a -q -z).
>
> Have you tried going 'VACUUM FULL ANALYZE' (vacuumdb -a -q -z -f)
> instead of a dump and reload?
>
> Chris
>
>
>





view thread (8+ messages)  latest in thread

Message-ID: <2b8e01c3b301$0bc2f090$0201a8c0@game>
Permalink:  ../2b8e01c3b301$0bc2f090$0201a8c0@game/
Also on:    postgresql.org/message-id/2b8e01c3b301$0bc2f090$0201a8c0@game

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: mk_spam@comcast.net, chriskl@familyhealth.com.au
  Subject: Re: Where to start for performance problem?
  In-Reply-To: <2b8e01c3b301$0bc2f090$0201a8c0@game>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox