Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B364A64FD9E for ; Tue, 28 Oct 2008 10:45:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 56539-01 for ; Tue, 28 Oct 2008 10:45:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id 9E19F64FD6A for ; Tue, 28 Oct 2008 10:45:08 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id c7so992352nfi.23 for ; Tue, 28 Oct 2008 06:45:07 -0700 (PDT) Received: by 10.210.12.18 with SMTP id 18mr8348711ebl.130.1225201507178; Tue, 28 Oct 2008 06:45:07 -0700 (PDT) Received: from ?88.195.116.231? (dsl-hkibrasgw2-ff74c300-231.dhcp.inet.fi [88.195.116.231]) by mx.google.com with ESMTPS id g12sm906340nfb.28.2008.10.28.06.45.05 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 28 Oct 2008 06:45:06 -0700 (PDT) Message-ID: <4907175F.8050409@enterprisedb.com> Date: Tue, 28 Oct 2008 15:45:03 +0200 Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.16 (X11/20080724) MIME-Version: 1.0 To: Tom Lane CC: Simon Riggs , PostgreSQL-development Subject: Re: Visibility map, partial vacuums References: <4905AE17.7090305@enterprisedb.com> <1225193108.3971.154.camel@ebony.2ndQuadrant> <49070C29.9090508@enterprisedb.com> <18941.1225199290@sss.pgh.pa.us> In-Reply-To: <18941.1225199290@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit From: Heikki Linnakangas X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/1403 X-Sequence-Number: 126420 Tom Lane wrote: > The harder part is propagating the bit to the visibility map, but I > gather you intend to only allow VACUUM to do that? Yep. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com