Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id E84221F34A28 for ; Wed, 28 Dec 2011 14:42:04 -0400 (AST) Received: from aperol.beccati.com ([93.94.29.238] helo=mail.beccati.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RfyRv-00018r-En for pgsql-performance@postgresql.org; Wed, 28 Dec 2011 18:42:04 +0000 Received: (qmail 45005 invoked from network); 28 Dec 2011 19:41:37 +0100 Received: from unknown (HELO ?192.168.1.202?) (matteo@beccati.com@88.149.176.119) by mail.beccati.com with SMTP; 28 Dec 2011 18:41:37 -0000 Message-ID: <4EFB62F1.2000700@beccati.com> Date: Wed, 28 Dec 2011 19:41:53 +0100 From: Matteo Beccati User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0 MIME-Version: 1.0 To: Claudio Freire CC: Tom Lane , =?UTF-8?B?U8O2cmVuIE1leWVyLUVwcGxlcg==?= , pgsql-performance@postgresql.org Subject: Re: PostgreSQL 9.0.4 blocking in lseek? References: <4EA82B7C.1040008@google.com> <9398.1319761978@sss.pgh.pa.us> <4EFAE7F6.30603@beccati.com> <4EFB59BC.9000208@beccati.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -3.2 (---) X-Archive-Number: 201112/195 X-Sequence-Number: 45994 On 28/12/2011 19:07, Claudio Freire wrote: > On Wed, Dec 28, 2011 at 3:02 PM, Matteo Beccati wrote: >> The query eventually completed in more than 18h. For comparison a normal >> run doesn't take more than 1m for that specific step. >> >> Do you think that bad stats and suboptimal plan alone could explain such >> a behaviour? > > Did you get the explain analyze output? Unfortunately I stopped it as I thought it wasn't going to return anything meaningful. I've restarted the import process and it will break right before the problematic query. Let's see if I can get any more info tomorrow. Cheers -- Matteo Beccati Development & Consulting - http://www.beccati.com/