Re: On-disk size of db increased after restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Richard Huxton <dev(at)archonet(dot)com>, PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: On-disk size of db increased after restore
Date: 2010-09-01 21:32:35
Message-ID: 1624.1283376755@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim(at)gunduz(dot)org> writes:
> Alvaro, this may be a stupid question but: I enabled custom autovac
> settings for some tables. These changes are included in the dump. May
> this affect on-disk size?

Doesn't seem likely that that would matter to the state immediately
after restoring; autovac should only affect things after you've done
some deletes/updates in the tables. But are you sure there aren't
some fillfactor tweaks in there too?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-09-01 21:39:55 Re: On-disk size of db increased after restore
Previous Message Devrim GÜNDÜZ 2010-09-01 21:04:40 Re: On-disk size of db increased after restore