Skip site navigation (1) Skip section navigation (2)

Re: Where to start for performance problem?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Nid <mk_spam(at)comcast(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Where to start for performance problem?
Date: 2003-11-25 03:18:48
Message-ID: 3FC2CA18.3080001@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
Nid wrote:

> 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.

Try upgrading to PostgreSQL 7.4 and use the new pg_autovacuum daemon. 
This daemon will monitor your tables and vacuum and analyze whenever 
necessary.

Chris



In response to

pgsql-performance by date

Next:From: Christopher BrowneDate: 2003-11-25 04:08:08
Subject: Re: [HACKERS] More detail on settings for pgavd?
Previous:From: NidDate: 2003-11-25 03:05:56
Subject: Re: Where to start for performance problem?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group