Postgres Professional
   

Re: cpu bound postgresql setup.

From: Bruce Momjian
Subject: Re: cpu bound postgresql setup.
Date: ,
Msg-id: 201006282144.o5SLiXw20469@momjian.us
(view: Whole thread, Raw)
In response to: Re: cpu bound postgresql setup.  ("Benjamin Krajmalnik")
Responses: Re: cpu bound postgresql setup.  ("Benjamin Krajmalnik")
List: pgsql-performance

Tree view

Re: cpu bound postgresql setup. Firstly many thanks for responding. I am concerned because the load averages have increased and users complaining of slowness. I do not change settings frequenly. I was curious if there is any half dead component in th  (Rajesh Kumar Mallah, )
 Re: cpu bound postgresql setup.  ("Kevin Grittner", )
 Re: cpu bound postgresql setup.  (Rajesh Kumar Mallah, )
  Re: cpu bound postgresql setup.  ("Kevin Grittner", )
   Re: cpu bound postgresql setup.  (Rajesh Kumar Mallah, )
    Re: cpu bound postgresql setup.  (Rajesh Kumar Mallah, )
     Re: cpu bound postgresql setup.  ("Benjamin Krajmalnik", )
      Re: cpu bound postgresql setup.  (Bruce Momjian, )
       Re: cpu bound postgresql setup.  ("Benjamin Krajmalnik", )
        Re: cpu bound postgresql setup.  (Bruce Momjian, )
    Re: cpu bound postgresql setup.  (Alvaro Herrera, )
    Re: cpu bound postgresql setup.  ("Kevin Grittner", ) 
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  <>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

pgsql-performance by date:

Previous:
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL as a local in-memory cache
Next:
From: Robert Haas
Date:
Subject: Re: PostgreSQL as a local in-memory cache