Re: On-disk size of db increased after restore

From: Richard Huxton <dev(at)archonet(dot)com>
To: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
Cc: PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: On-disk size of db increased after restore
Date: 2010-09-01 20:13:55
Message-ID: 4C7EB403.7080007@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-09-01 20:32:00 Re: On-disk size of db increased after restore
Previous Message Tom Lane 2010-09-01 17:02:19 Re: How to defer ON DELETE CASCADE