Postgres Pro
Downloads
Home   >   mailing lists

Re: high user cpu, massive SELECTs, no io waiting problem - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: high user cpu, massive SELECTs, no io waiting problem
Date
Msg-id 4D5A6C60020000250003AA98@gw.wicourts.gov
Whole thread Raw
In response to high user cpu, massive SELECTs, no io waiting problem  (Thomas Pöhler <tp@turtle-entertainment.de>)
Responses Re: high user cpu, massive SELECTs, no io waiting problem
List pgsql-performance
Tree view 
Thomas Pöhler<tp@turtle-entertainment.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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: high user cpu, massive SELECTs, no io waiting problem
Next
From: Mark Mikulec
Date:
Subject: pg_dumpall affecting performance