Re: How to specify fillrate after pg_restore? - Mailing list pgsql-admin

From Tom Lane
Subject Re: How to specify fillrate after pg_restore?
Date
Msg-id 1702.1222832176@sss.pgh.pa.us
Whole thread Raw
In response to How to specify fillrate after pg_restore?  (Laszlo Nagy <gandalf@shopzeus.com>)
Responses Re: How to specify fillrate after pg_restore?  (Michael Monnerie <michael.monnerie@is.it-management.at>)
List pgsql-admin
Laszlo Nagy <gandalf@shopzeus.com> writes:
> What will this do?

> ALTER TABLE tbl SET FILLFACTOR = 90;

> Will it restucture the table, or is it just a setting and I should
> perform a VACUUM to actually reach fillfactor=90?

It's just a setting ... and VACUUM won't do much with it either.

The best bet at the moment is to manually edit the pg_dump script
to insert such a command between creating the table and loading it.

            regards, tom lane

pgsql-admin by date:

Previous
From: Craig Perras
Date:
Subject: sspi authentication
Next
From: Michael Monnerie
Date:
Subject: Re: [GENERAL] 8.3.4 rpms for Opensuse10.3 64bit