Re: High load,

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 1/27/2011 9:09 AM, Michael Kohl wrote:
On Thu, Jan 27, 2011 at 4:06 PM, Andy Colson<andy@xxxxxxxxxxxxxxx>  wrote:
Have you run each of your queries through explain analyze lately?

A code review including checking of queries is on our agenda.

You are vacuuming/autovacuuming, correct?

Sure :-)

Thank you,
Michael


Oh, also, when the box is really busy, have you watched vmstat to see if you start swapping?

-Andy

--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux