Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C92A09FB5FB for ; Wed, 6 Jun 2007 16:57:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 74313-01-4 for ; Wed, 6 Jun 2007 16:56:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id A57579FA410 for ; Wed, 6 Jun 2007 16:56:55 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1Hw1ck-0000y6-RE for pgsql-performance@postgresql.org; Wed, 06 Jun 2007 15:56:54 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 87F964050; Wed, 6 Jun 2007 15:56:49 -0400 (EDT) Date: Wed, 6 Jun 2007 15:56:49 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: VERY slow queries at random Message-ID: <20070606195649.GG11545@phlogiston.dyndns.org> References: <46670916.9090505@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <46670916.9090505@gmail.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/106 X-Sequence-Number: 25139 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