Brian Hurt <bhurt@janestcapital.com> 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 combined with other transactions over a long
enough time period can very predictably lead to this type of behavior
One simple way to see if you have any long running transactions is to look for
PIDs that are "idle in transaction" for long periods of time.
robert