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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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