On Fri, Jul 11, 2008 at 12:12 PM, Richard Broersma
<richard.broersma@gmail.com> wrote:
> On Fri, Jul 11, 2008 at 10:27 AM, Scott Marlowe <scott.marlowe@gmail.com> 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.