Postgres Pro
Downloads
Home   >   mailing lists

Re: Postmaster taking 100% of the CPU - Mailing list pgsql-general

From Vick Khera
Subject Re: Postmaster taking 100% of the CPU
Date
Msg-id 2968dfd60910261247p353dbfb2k7c89e9bcb6e62f14@mail.gmail.com
Whole thread Raw
In response to Postmaster taking 100% of the CPU  (David Kerr <dmk@mr-paradox.net>)
List pgsql-general
Tree view 
On Mon, Oct 26, 2009 at 1:30 PM, David Kerr <dmk@mr-paradox.net> wrote:
> Postmaster's been spinning at 99/100% for a few hours.
>

What does "select * from pg_stat_activity" show you?   Look for your
long(est) running query.

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [ANNOUNCE] [pgeu-general] PGDay.EU 2009 - approaching fast!
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: joining an array with a table or...?