On Fri, Jul 11, 2008 at 12:12 PM, Richard Broersma <richard.broersma@xxxxxxxxx> wrote: > 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 ); 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.
