Postgres Pro
Downloads
Home   >   mailing lists

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

From Devrim GÜNDÜZ
Subject Re: On-disk size of db increased after restore
Date
Msg-id 1283373120.2484.1.camel@hp-laptop2.gunduz.org
Whole thread Raw
In response to Re: On-disk size of db increased after restore  (Richard Huxton <dev@archonet.com>)
Responses Re: On-disk size of db increased after restore  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
Hi,

On Wed, 2010-09-01 at 21:13 +0100, Richard Huxton wrote:
>
> Could you have changed the fillfactor on some big tables/indexes in
> the  live database after populating them?

Nope. Even a pg_dump -h prod|psql backup_node resulted with the same
issue

> Is the locale the same on each machine/db?

These are generic RPM installations, and locales are the same...

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
Attachment

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: On-disk size of db increased after restore
Next
From: Richard Huxton
Date:
Subject: Re: On-disk size of db increased after restore