Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: On-disk size of db increased after restore
Date
Msg-id 1624.1283376755@sss.pgh.pa.us
Whole thread Raw
In response to Re: 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
List pgsql-general
Tree view 
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@gunduz.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

pgsql-general by date:

Previous
From: Phil Jackson
Date:
Subject: Problems with ODBC Driver
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: On-disk size of db increased after restore