Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] Postgres locking up? - Mailing list pgsql-performance

From Tom Lane
Subject Re: [NOVICE] Postgres locking up?
Date
Msg-id 3233.1159563485@sss.pgh.pa.us
Whole thread Raw
In response to Postgres locking up?  (Brian Hurt <bhurt@janestcapital.com>)
List pgsql-performance
Tree view 
Brian Hurt <bhurt@janestcapital.com> writes:
> I'm experiencing a problem with our postgres database.  Queries that
> normally take seconds suddenly start taking hours, if they complete at
> all.

Are they waiting?  Consuming CPU?  Consuming I/O?  top and vmstat will
help you find out.

            regards, tom lane

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Postgres locking up?
Next
From: gurkan@resolution.com
Date:
Subject: cont. how to optimize postgres 8.1