On Fri, Jul 11, 2008 at 10:27 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
> Is there any way to set a different default fill factor?
ALTER TABLE Yourtable
SET ( FILLFACTOR = 50 );
It take a bit of back tracking on the storage_parameter section:
http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html <-
see storage_parameter
http://www.postgresql.org/docs/8.3/interactive/sql-createtable.html <-
see storage_parameter
http://www.postgresql.org/docs/8.3/interactive/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS
<- see FILLFACTOR
--
Regards,
Richard Broersma Jr.
Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
