Re: Postgres locking up? - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Postgres locking up?
Date
Msg-id 20060929193006.GF23697@phlogiston.dyndns.org
Whole thread Raw
In response to Postgres locking up?  (Brian Hurt <bhurt@janestcapital.com>)
List pgsql-performance
On Fri, Sep 29, 2006 at 03:24:14PM -0400, Brian Hurt wrote:
> I'm experiencing a problem with our postgres database.  Queries that
> normally take seconds suddenly start taking hours, if they complete at
> all.

The first thing I'd do is EXPLAIN and EXPLAIN ANALYSE on the queries
in question.

The next thing I'd look for is OS-level performance problems.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what
you told them to.  That actually seems sort of quaint now.
        --J.D. Baldwin

pgsql-performance by date:

Previous
From: Brian Hurt
Date:
Subject: Postgres locking up?
Next
From: Tom Lane
Date:
Subject: Re: [NOVICE] Postgres locking up?