Skip site navigation (1) Skip section navigation (2)

Re: cpu bound postgresql setup.

From: "Benjamin Krajmalnik" <kraj(at)servoyant(dot)com>
To: "Bruce Momjian" <bruce(at)momjian(dot)us>
Cc: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>,"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: cpu bound postgresql setup.
Date: 2010-06-29 15:11:53
Message-ID: F4E6A2751A2823418A21D4A160B68988614660@fletch.stackdump.local (view raw or flat)
Thread:
Lists: pgsql-performance
Bruce,
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-
> performance(at)postgresql(dot)org
> Subject: Re: [PERFORM] cpu bound postgresql setup.
> 
> Benjamin Krajmalnik wrote:
> > Rajesh,
> >
> > I had a similar situation a few weeks ago whereby performance all of
> a
> > sudden decreased.
> > The one tunable which resolved the problem in my case was increasing
> the
> > 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

Responses

pgsql-performance by date

Next:From: Bruce MomjianDate: 2010-06-29 15:29:18
Subject: Re: cpu bound postgresql setup.
Previous:From: Kevin GrittnerDate: 2010-06-29 14:14:13
Subject: Re: PostgreSQL as a local in-memory cache

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group