Re: Default fill factor for tables? - Mailing list pgsql-general

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.