Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 65F55B5DC45 for ; Thu, 27 Oct 2011 09:04:09 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 73153-04-2 for ; Thu, 27 Oct 2011 12:04:03 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from smtp-out.google.com (smtp-out.google.com [216.239.44.51]) by mail.postgresql.org (Postfix) with ESMTP id DEBABB5DCA5 for ; Thu, 27 Oct 2011 09:03:51 -0300 (ADT) Received: from hpaq6.eem.corp.google.com (hpaq6.eem.corp.google.com [172.25.149.6]) by smtp-out.google.com with ESMTP id p9RC3oVC028241 for ; Thu, 27 Oct 2011 05:03:51 -0700 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=google.com; s=beta; t=1319717031; bh=UavSoA+/SBI/R39QCSbuI4Xtigc=; h=Message-ID:Date:From:MIME-Version:To:CC:Subject:References: In-Reply-To:Content-Type:Content-Transfer-Encoding; b=dPab4ghJCfXBKkA1lCWDaEFxy1R4vQmAU91/gbKFqQcBcDLyYtXtbym22lB5wdL3p w8mccWZVOtUt03zCxQGQQ== DomainKey-Signature: a=rsa-sha1; s=beta; d=google.com; c=nofws; q=dns; h=dkim-signature:message-id:date:from:user-agent: mime-version:to:cc:subject:references:in-reply-to:content-type: content-transfer-encoding:x-system-of-record; b=ZA5bblorNgAY0t5HQXzaLJEc9HNuaqoPmTF7cbJPHVWaAzpaGYcvNttne25GSAyaN e4Wz9v5tlWtbFtw2UyShg== Received: from wwg38 (wwg38.prod.google.com [10.241.242.166]) by hpaq6.eem.corp.google.com with ESMTP id p9RC1Qj0025868 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=NOT) for ; Thu, 27 Oct 2011 05:03:49 -0700 Received: by wwg38 with SMTP id 38so1142463wwg.2 for ; Thu, 27 Oct 2011 05:03:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=beta; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=eG4lzhu/2DUzmTYh4QcLq+Ng39cB0mpxd6e9lpEXnh8=; b=DXjYWXfweia5NJKN8SffuOQnCjI5iSav6SRmJspCY0L0T0aqAtr6UqQaIzOE/Fi3X7 98nGwgluVM1h3cijvqcA== Received: by 10.227.199.5 with SMTP id eq5mr16231776wbb.2.1319717029293; Thu, 27 Oct 2011 05:03:49 -0700 (PDT) Received: by 10.227.199.5 with SMTP id eq5mr16231737wbb.2.1319717028981; Thu, 27 Oct 2011 05:03:48 -0700 (PDT) Received: from ?IPv6:2620:0:105f:1:381b:c850:8ad9:74ee? ([2620:0:105f:1:381b:c850:8ad9:74ee]) by mx.google.com with ESMTPS id gd18sm8974519wbb.5.2011.10.27.05.03.47 (version=SSLv3 cipher=OTHER); Thu, 27 Oct 2011 05:03:48 -0700 (PDT) Message-ID: <4EA948A2.4030602@google.com> Date: Thu, 27 Oct 2011 14:03:46 +0200 From: =?UTF-8?B?U8O2cmVuIE1leWVyLUVwcGxlcg==?= User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1 MIME-Version: 1.0 To: Gregg Jaskiewicz CC: pgsql-performance@postgresql.org Subject: Re: PostgreSQL 9.0.4 blocking in lseek? References: <4EA82B7C.1040008@google.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-System-Of-Record: true X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.404 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201110/228 X-Sequence-Number: 45450 On 2011-10-27 09:42, Gregg Jaskiewicz wrote: > What does 'select * from pg_stat_activity' say, more precisely - the > "waiting" column. Waiting is "false" for all rows. If I use pgadmin to lock at the server status all locks have been granted for hours. Although the process does in fact use CPU this time, strace still gives a seemingly endless list of lseek calls.