| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice 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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frances Collier | 2006-09-29 20:02:17 | Cancelled statement due to lost connection |
| Previous Message | Brian Hurt | 2006-09-29 19:24:14 | Postgres locking up? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-09-29 20:58:05 | Re: Postgres locking up? |
| Previous Message | Brian Hurt | 2006-09-29 19:24:14 | Postgres locking up? |