Re: Huge performance problem between 7.4.1 and 8.0.3 - CS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, PGPerformance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS
Date: 2005-07-18 04:18:30
Message-ID: 24616.1121660310@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> writes:
> I am, and it is. It's ANALYZING and VACUUM'ing tables every interval (5 mi=
> nutes
> - 8.0.3). Right now, for that last 4 hours, I'm not VACUUMing the 7.4.1
> database and it's still clicking along at < .2 second queries.

Have you compared physical table sizes? If the autovac daemon did let
things get out of hand, you'd need a VACUUM FULL or CLUSTER or TRUNCATE
to get the table size back down --- plain VACUUM is unlikely to fix it.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew T. O'Connor 2005-07-18 04:18:43 Re: Huge performance problem between 7.4.1 and 8.0.3 -
Previous Message David Mitchell 2005-07-18 04:17:54 Re: Huge performance problem between 7.4.1 and 8.0.3 -