Re: VERY slow queries at random - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: VERY slow queries at random
Date
Msg-id 20070606195649.GG11545@phlogiston.dyndns.org
Whole thread Raw
In response to VERY slow queries at random  (Gunther Mayer <gunther.mayer@googlemail.com>)
Responses Re: VERY slow queries at random
List pgsql-performance
On Wed, Jun 06, 2007 at 09:20:54PM +0200, Gunther Mayer wrote:
>
> What the heck could cause such erratic behaviour? I suspect some type of
> resource problem but what and how could I dig deeper?

Is something (perhaps implicitly) locking the table?  That will cause
this.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.
        --H.W. Fowler

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: control of benchmarks (was: Thousands of tables)
Next
From: "Jonah H. Harris"
Date:
Subject: Re: control of benchmarks (was: Thousands of tables)