postgres.exe 100% CPU but no I/O

From: Robert Schnabel <schnabelr(at)missouri(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: postgres.exe 100% CPU but no I/O
Date: 2009-01-24 17:01:19
Message-ID: 497B495F.6040309@missouri.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all, I recently noticed that I have a postgres.exe process running at
100% CPU but is not doing any I/O. This is fresh off of starting the
service. This is a local db so I am the only one using it and it will
do this even if I do not have any queries running. I have let it run
for about 2 days (not running any queries) but it never stops so I
figured I'd ask for some advice. I upgraded to 8.2.11 about a month ago
and haven't had any issues so this seems to be a recent development
within the last week. I guess my question is how should I go about
tracking down the cause of this running wild? I'm running Win XP64 SP2,
Postgre 8.2.11.

Thanks in advance for any pointers.
Bob

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Daniel Staal 2009-01-24 18:19:48 Re: SQL Question: Averages of intervals.
Previous Message Rodrigo E. De León Plicet 2009-01-24 16:16:31 Re: SQL Question: Averages of intervals.