Skip site navigation (1) Skip section navigation (2)

Re: Postgres locking up?

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres locking up?
Date: 2006-09-29 19:30:06
Message-ID: 20060929193006.GF23697@phlogiston.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-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(at)crankycanuck(dot)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

In response to

pgsql-novice by date

Next:From: Frances CollierDate: 2006-09-29 20:02:17
Subject: Cancelled statement due to lost connection
Previous:From: Brian HurtDate: 2006-09-29 19:24:14
Subject: Postgres locking up?

pgsql-performance by date

Next:From: Tom LaneDate: 2006-09-29 20:58:05
Subject: Re: Postgres locking up?
Previous:From: Brian HurtDate: 2006-09-29 19:24:14
Subject: Postgres locking up?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group