X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2A7EE533F2 for ; Wed, 30 Mar 2005 16:19:11 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25494-10 for ; Wed, 30 Mar 2005 15:19:03 +0000 (GMT) Received: from sunsite.dcc.uchile.cl (sunsite.dcc.uchile.cl [192.80.24.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0B630533C9 for ; Wed, 30 Mar 2005 16:19:02 +0100 (BST) Received: from anakena.dcc.uchile.cl (anakena [192.80.24.6]) by sunsite.dcc.uchile.cl (8.12.11/8.12.11) with ESMTP id j2UFJ3IV012731; Wed, 30 Mar 2005 11:19:04 -0400 (CLT) Received: by anakena.dcc.uchile.cl (Postfix, from userid 4151) id C999D529D3; Wed, 30 Mar 2005 11:19:03 -0400 (CLT) Date: Wed, 30 Mar 2005 11:19:03 -0400 From: Alvaro Herrera To: Karim Nassar Cc: pgsql-performance@postgresql.org Subject: Re: VACUUM on duplicate DB gives FSM and total pages discrepancies Message-ID: <20050330151903.GD32434@dcc.uchile.cl> References: <1112143978.9077.29.camel@k2.cet.nau.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1112143978.9077.29.camel@k2.cet.nau.edu> User-Agent: Mutt/1.5.8i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.344 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200503/649 X-Sequence-Number: 11354 On Tue, Mar 29, 2005 at 05:52:58PM -0700, Karim Nassar wrote: > I recently pg_dumpall'd my DB from a (used for testing) v20z install of > postgresql 8.0.1, and restored it to my production (but not yet in > service) v40z running the same version. The test DB has had multiple > millions of rows created/dropped during testing. The results of VACUUM > VERBOSE are giving me pause: The FSM only stores pages that have some free space. If the database has only been through a restore, then probably there aren't many of those. After you start playing with the data some more pages will need registering. So the behavior you are seeing is expected. -- Alvaro Herrera () "We are who we choose to be", sang the goldfinch when the sun is high (Sandman)