Re: How to specify fillrate after pg_restore?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Laszlo Nagy <gandalf@xxxxxxxxxxxx> 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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux