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

From Robert Creager
Subject Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?
Date
Msg-id 20050718122103.0000064a@C118181.stortek.com
Whole thread Raw
In response to Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Mon, 18 Jul 2005 13:52:53 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Start a fresh psql session and "SHOW vacuum_cost_delay" to verify what
> the active setting is.

Thanks.  It does show 0 for 803 in a session that was up since I thought I had
HUPed the server with the new value.

This is leading me to believe that 803 doesn't do very well with VACUUM ANALYZE
running often, at least in my particular application...  I will provide a more
definitive statement to that affect, hopefully tonight.

Cheers,
Rob

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: join and query planner
Next
From: Vivek Khera
Date:
Subject: Re: Impact of checkpoint_segments under continual load conditions