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

Re: Huge performance problem between 7.4.1 and 8.0.3 -

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
Cc: PGPerformance <pgsql-performance(at)postgresql(dot)org>,Andy Hewitt <Andy_Hewitt(at)StorageTek(dot)com>
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 -
Date: 2005-07-18 03:48:20
Message-ID: 42DB2684.9020706@zeut.net (view raw or flat)
Thread:
Lists: pgsql-performance
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.


In response to

Responses

pgsql-performance by date

Next:From: Robert CreagerDate: 2005-07-18 04:10:50
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS
Previous:From: Robert CreagerDate: 2005-07-18 03:34:16
Subject: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?

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