Postgres Pro
Downloads
Home   >   mailing lists

Re: Huge performance problem between 7.4.1 and 8.0.3 - - Mailing list pgsql-performance

From Matthew T. O'Connor
Subject Re: Huge performance problem between 7.4.1 and 8.0.3 -
Date
Msg-id 42DB2684.9020706@zeut.net
Whole thread Raw
In response to Huge performance problem between 7.4.1 and 8.0.3 - CS issue?  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Responses Re: Huge performance problem between 7.4.1 and 8.0.3 - CS
List pgsql-performance
Tree view 
Robert Creager wrote:

>For 8.03, pg_autovacuum is running.  On 7.4.1, I set up a cron job to vacuum
>analyze every 5 minutes.
>
>

Are you sure that pg_autovacuum is doing it's job?  Meaning are you sure
it's vacuuming as often as needed?  Try to run it with -d2 or so and
make sure that it is actually doing the vacuuming needed.

pgsql-performance by date:

Previous
From: Robert Creager
Date:
Subject: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?
Next
From: Robert Creager
Date:
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS