Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 77080B5DC27 for ; Mon, 31 Oct 2011 10:56:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 74668-04 for ; Mon, 31 Oct 2011 13:56:37 +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 5957CB5DC23 for ; Mon, 31 Oct 2011 10:56:37 -0300 (ADT) Received: from hpaq13.eem.corp.google.com (hpaq13.eem.corp.google.com [172.25.149.13]) by smtp-out.google.com with ESMTP id p9VDuaEF001943 for ; Mon, 31 Oct 2011 06:56:36 -0700 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=google.com; s=beta; t=1320069397; bh=//yqItFsRBO2zMvQDs52dGJSJbw=; h=Message-ID:Date:From:MIME-Version:To:CC:Subject:References: In-Reply-To:Content-Type:Content-Transfer-Encoding; b=hRR2St8yRvpUn/XYyrEkXVl51yJrgV0yn5oM+3/wUcjT5fYGcNIDvn9I6UJ7JA6U9 Jt6uaAt30Wcn20DlBebZw== 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=odwTP0NgH5YT+sYzUoeaTB+62bU05ItcsCEeZRVQxgBmrNGdp2Oj+pPC8YoucxVR0 8FTsr/taw8SbbDl7m0G8Q== Received: from faak28 (faak28.prod.google.com [10.223.15.156]) by hpaq13.eem.corp.google.com with ESMTP id p9VDuMeT031219 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=NOT) for ; Mon, 31 Oct 2011 06:56:35 -0700 Received: by faak28 with SMTP id k28so2435480faa.3 for ; Mon, 31 Oct 2011 06:56:34 -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=9PldAJ1qUxOl/5TxJv3L6pyM4whE/Td+PWo7JbH0Dr0=; b=JWc6mD0rac7+P0WPBUTQ1bXsU8yuvU32NKJajal49xj+HbiK918cbDvxSVOu6Bwvav 8B53pKj90J7zueahLHRw== Received: by 10.223.81.196 with SMTP id y4mr29446705fak.6.1320069394884; Mon, 31 Oct 2011 06:56:34 -0700 (PDT) Received: by 10.223.81.196 with SMTP id y4mr29446679fak.6.1320069394658; Mon, 31 Oct 2011 06:56:34 -0700 (PDT) Received: from ?IPv6:2620:0:105f:1:d42e:c230:45d0:32a5? ([2620:0:105f:1:d42e:c230:45d0:32a5]) by mx.google.com with ESMTPS id x19sm30473372fag.5.2011.10.31.06.56.33 (version=SSLv3 cipher=OTHER); Mon, 31 Oct 2011 06:56:33 -0700 (PDT) Message-ID: <4EAEA910.9070000@google.com> Date: Mon, 31 Oct 2011 14:56:32 +0100 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: Josh Berkus CC: pgsql-performance@postgresql.org Subject: Re: PostgreSQL 9.0.4 blocking in lseek? References: <4EA82B7C.1040008@google.com> <4EAA1679.6060201@agliodbs.com> In-Reply-To: <4EAA1679.6060201@agliodbs.com> 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=-3.101 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-1.201 X-Spam-Level: X-Archive-Number: 201110/275 X-Sequence-Number: 45497 > (1) is it *only* that query? No. There seem to be one or two others exhibiting similarly bad performance. > (2) is there some reason you might have excessive disk fragmentation, > like running on a VM? No VM. The database is the only thing running on the server. Filesystem is XFS.