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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Creager <Robert_Creager(at)StorageTek(dot)com>
Cc: matthew(at)zeut(dot)net, pgsql-performance(at)postgresql(dot)org, Andy Hewitt III <ralph_hewitt_iii(at)StorageTek(dot)com>
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?
Date: 2005-07-18 17:52:53
Message-ID: 15472.1121709173@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Robert Creager <Robert_Creager(at)StorageTek(dot)com> writes:
> Around 8:15 I was starting to receive hits of a few seconds of high CS hits,
> higher than the previous 7 hour run on 741. I changed the vacuum delay to 0 and
> HUP'ed the server (how can I see the value vacuum_cost_delay run
> time?).

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

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2005-07-18 17:57:31 Re: join and query planner
Previous Message Robert Creager 2005-07-18 17:49:52 Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?