Re: high user cpu, massive SELECTs, no io waiting problem

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-performance(at)postgresql(dot)org>, Thomas Pöhler <tp(at)turtle-entertainment(dot)de>
Cc: "Verteiler_A-Team" <a-team(at)turtle-entertainment(dot)de>, <bm(at)turtle-entertainment(dot)de>, "Felix Feinhals" <ff(at)turtle-entertainment(dot)de>
Subject: Re: high user cpu, massive SELECTs, no io waiting problem
Date: 2011-02-15 18:06:56
Message-ID: 4D5A6C60020000250003AA98@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thomas Pöhler<tp(at)turtle-entertainment(dot)de> wrote:

> we have lots of SELECTs running.

How many?

Could you show your postgresql.conf file, with all comments removed?

What does vmstat 1 (or similar) show at baseline and during your
problem episodes?

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Mikulec 2011-02-15 18:41:04 pg_dumpall affecting performance
Previous Message Scott Marlowe 2011-02-15 18:01:53 Re: high user cpu, massive SELECTs, no io waiting problem