X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 79550D1B52E for ; Sun, 5 Oct 2003 18:44:05 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 88853-05 for ; Sun, 5 Oct 2003 15:43:20 -0300 (ADT) Received: from wight.ymogen.net (unknown [217.27.240.153]) by svr1.postgresql.org (Postfix) with SMTP id 6F65FD1B54E for ; Sun, 5 Oct 2003 15:43:17 -0300 (ADT) Received: (qmail 22221 invoked from network); 5 Oct 2003 18:43:18 -0000 Received: from dsl-217-155-239-51.zen.co.uk (HELO finisterre) (217.155.239.51) by wight.ymogen.net with SMTP; 5 Oct 2003 18:43:18 -0000 From: "Matt Clark" To: "Tom Lane" Cc: "Andrew Sullivan" , Subject: Re: reindex/vacuum locking/performance? Date: Sun, 5 Oct 2003 19:43:17 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <6652.1065377233@sss.pgh.pa.us> Importance: Normal X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/159 X-Sequence-Number: 3907 > Mainly 'cause it doesn't know where the dead tuples are till it's > looked. At this point I feel very stupid... > Also, VACUUM is the data collector for the free space map, > and so it is also charged with finding out how much free space exists > on every page. Ah, now I just feel enlightened! That makes perfect sense. I think I had been conflating free pages with free space, without understanding what the difference was. Of course I still don't really understand, but at least I now _know_ I don't. Many thanks Matt