I'm experiencing a problem with our postgres database. Queries that
normally take seconds suddenly start taking hours, if they complete at
all.
This isn't a vacuuming or analyzing problem- I've been on this list long
enough that they were my first response, and besides it doesn't happen
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
Brian Hurt [EMAIL PROTECTED] wrote:
I'm experiencing a problem with our postgres database. Queries that
normally take seconds suddenly start taking hours, if they complete at
all.
Do you have any long running transactions? I have noticed that with Postgres
8.1.x, a long running transaction