Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: On-disk size of db increased after restore
Date
Msg-id 4C7EB403.7080007@archonet.com
Whole thread Raw
In response to 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  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List pgsql-general
Tree view 
On 31/08/10 22:17, Devrim GÜNDÜZ wrote:
> I have seen the opposite of this tons of times before, but I haven't
> seen an increase after restore before. Does anyone know what may cause
> this? Where should I look at?

Could you have changed the fillfactor on some big tables/indexes in the
live database after populating them?

Is the locale the same on each machine/db?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to defer ON DELETE CASCADE
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: On-disk size of db increased after restore