On Fri, Jul 11, 2008 at 10:27 AM, Scott Marlowe <[EMAIL PROTECTED]> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to