Re: cpu bound postgresql setup. - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: cpu bound postgresql setup.
Date
Msg-id 201006282144.o5SLiXw20469@momjian.us
Whole thread Raw
In response to Re: cpu bound postgresql setup.  ("Benjamin Krajmalnik" <kraj@servoyant.com>)
Responses Re: cpu bound postgresql setup.  ("Benjamin Krajmalnik" <kraj@servoyant.com>)
List pgsql-performance
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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + None of us is going to be here forever. +

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: order by slowing down a query by 80 times
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL as a local in-memory cache