Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 29 Sep 2006 15:30:06 -0400
- Message-id: <20060929193006(dot)GF23697(at)phlogiston(dot)dyndns(dot)org>
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
- References:
- Postgres locking up?
- From: Brian Hurt
- Postgres locking up?
- Prev by Date: Postgres locking up?
- Next by Date: Re: [NOVICE] Postgres locking up?
- Previous by thread: Postgres locking up?
- Next by thread: Re: [NOVICE] Postgres locking up?
- Indexes: