Re: How to specify fillrate after pg_restore?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to specify fillrate after pg_restore?
Date: 2008-10-01 03:36:16
Message-ID: 1702.1222832176@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Laszlo Nagy <gandalf(at)shopzeus(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Monnerie 2008-10-01 14:54:23 Re: [GENERAL] 8.3.4 rpms for Opensuse10.3 64bit
Previous Message Craig Perras 2008-10-01 01:21:08 sspi authentication