pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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)



view thread (2+ messages)

Message-ID: <20050330151903.GD32434@dcc.uchile.cl>
Permalink:  ../20050330151903.GD32434@dcc.uchile.cl/
Also on:    postgresql.org/message-id/20050330151903.GD32434@dcc.uchile.cl

 · 

reply

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