Unfortunately not. The behavior I had was ebbs and flows. On FreeBSD,
I was seeing a lot of kernel wait states in top. So every few minutes,
responsiveness of the db was pretty bad. 8.4.4/amd64 on FreeBSD 7.2
> -----Original Message-----
> From: Bruce Momjian [mailto:bruce(at)momjian(dot)us]
> Sent: Monday, June 28, 2010 3:45 PM
> To: Benjamin Krajmalnik
> Cc: Rajesh Kumar Mallah; Kevin Grittner; pgsql-
> Subject: Re: [PERFORM] cpu bound postgresql setup.
> Benjamin Krajmalnik wrote:
> > Rajesh,
> > I had a similar situation a few weeks ago whereby performance all of
> > sudden decreased.
> > The one tunable which resolved the problem in my case was increasing
> > number of checkpoint segments.
> > After increasing them, everything went back to its normal state.
> Did you get a db server log message suggesting in increasing that
> setting? I hope so.
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
> + None of us is going to be here forever. +
In response to
pgsql-performance by date
|Next:||From: Bruce Momjian||Date: 2010-06-29 15:29:18|
|Subject: Re: cpu bound postgresql setup.|
|Previous:||From: Kevin Grittner||Date: 2010-06-29 14:14:13|
|Subject: Re: PostgreSQL as a local in-memory cache|