From: Alvaro Herrera <alvherre@dcc.uchile.cl>
To: Karim Nassar <karim.nassar@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: VACUUM on duplicate DB gives FSM and total pages discrepancies
Date: Wed, 30 Mar 2005 11:19:03 -0400
Message-ID: <20050330151903.GD32434@dcc.uchile.cl> (raw)
In-Reply-To: <1112143978.9077.29.camel@k2.cet.nau.edu>
References: <1112143978.9077.29.camel@k2.cet.nau.edu>
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 (<alvherre[@]dcc.uchile.cl>)
"We are who we choose to be", sang the goldfinch
when the sun is high (Sandman)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@dcc.uchile.cl, karim.nassar@acm.org
Subject: Re: VACUUM on duplicate DB gives FSM and total pages discrepancies
In-Reply-To: <20050330151903.GD32434@dcc.uchile.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox