Re: On-disk size of db increased after restore - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: On-disk size of db increased after restore
Date
Msg-id 1283447241-sup-4629@alvh.no-ip.org
Whole thread Raw
In response to Re: On-disk size of db increased after restore  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Responses Re: On-disk size of db increased after restore  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Excerpts from Devrim GÜNDÜZ's message of mié sep 01 17:39:55 -0400 2010:
> On Wed, 2010-09-01 at 17:32 -0400, Tom Lane wrote:
> > But are you sure there aren't some fillfactor tweaks in there too?
>
> I'm sure. fillfactor related changes are on the radar, but I did not
> commit them yet...

Maybe you're on one of these versions on which, if you tweaked the
autovacuum settings, the fillfactor magically got moved to some other
value.

Can you check how full the pages are?  There's a contrib module for
that, I don't recall the name.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: System catalog changes between 9.0 beta4 and rc1
Next
From: Thom Brown
Date:
Subject: Re: System catalog changes between 9.0 beta4 and rc1