On Fri, Jul 11, 2008 at 12:12 PM, Richard Broersma <[EMAIL PROTECTED]> wrote: > 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 );
Hehe. I know how to do that. I mean the default fill factor for a database / user for tables / indexes.. Like setting search_path for a user. alter database mydb set indexfillfactor=50; alter user me set tablefillfactor=75; so that newly created indexes in the db mydb have fillfactor of 50 and tables created by me are at 75. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
