Search Postgresql Archives

Re: On-disk size of db increased after restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxx>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux