Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 354CA2E3302 for ; Fri, 14 Dec 2007 15:40:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 82553-02 for ; Fri, 14 Dec 2007 15:40:42 -0400 (AST) Received: from serv01.siteground137.com (ns1.siteground137.com [67.15.250.10]) by postgresql.org (Postfix) with ESMTP id 34BE92E330E for ; Fri, 14 Dec 2007 15:40:45 -0400 (AST) Received: from cragnux.laika.com ([209.162.219.253]:61072 helo=dogma.ljc.laika.com) by serv01.siteground137.com with esmtpa (Exim 4.68) (envelope-from ) id 1J3GOm-0004R2-Kk for pgsql-performance@postgresql.org; Fri, 14 Dec 2007 13:40:41 -0600 Subject: Re: explanation for seeks in VACUUM (8.2.4) From: Jeff Davis To: pgsql-performance@postgresql.org In-Reply-To: <1197660594.28804.276.camel@dogma.ljc.laika.com> References: <1197660594.28804.276.camel@dogma.ljc.laika.com> Content-Type: text/plain Date: Fri, 14 Dec 2007 11:40:37 -0800 Message-Id: <1197661237.28804.278.camel@dogma.ljc.laika.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-7) Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - serv01.siteground137.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - j-davis.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/225 X-Sequence-Number: 28041 On Fri, 2007-12-14 at 11:29 -0800, Jeff Davis wrote: > "bigtable" has about 60M records, about 2M of which are dead at the time > of VACUUM. Shared_buffers are about 1GB, and the machine has 4GB of > memory. Forgot to mention: version 8.2.4 Regards, Jeff Davis