Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 271B86346BB for ; Tue, 6 Apr 2010 01:06:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 37341-10 for ; Tue, 6 Apr 2010 04:06:05 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp2.ca.com (smtp2.ca.com [141.202.248.13]) by mail.postgresql.org (Postfix) with ESMTP id 7B523634FA3 for ; Tue, 6 Apr 2010 01:05:05 -0300 (ADT) Received: from athena.ca.com ([130.200.164.17]) by smtp2.ca.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 6 Apr 2010 00:05:04 -0400 Message-ID: <4BBAB2B7.5010909@ca.com> Date: Mon, 05 Apr 2010 21:04:07 -0700 From: Brian Cox User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.5) Gecko/20091204 Lightning/1.0b1 Thunderbird/3.0 MIME-Version: 1.0 To: "Craig Ringer [craig@postnewspapers.com.au]" CC: "pgsql-performance@postgresql.org" Subject: Re: query slow; strace output worrisome Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 06 Apr 2010 04:05:04.0420 (UTC) FILETIME=[5630AE40:01CAD53E] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.623 tagged_above=-10 required=5 tests=AWL=0.622, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201004/44 X-Sequence-Number: 38294 On 04/05/2010 09:53 PM, Craig Ringer [craig@postnewspapers.com.au] wrote: > Anything in `dmesg' (command) or /var/log/syslog ? nothing out of the ordinary. Brian