Re: [GENERAL] Default fill factor for tables?

> >
> >> 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.
>
Why would you set the fillfactor to anything other than 100 for a
PostgreSQL table?

http://www.postgresql.org/docs/8.3/static/routine-vacuuming.html

I thought an updated record always got a new row in a table. Setting a
lower fillfactor for a table suggests that PostgreSQL behaves like
Oracle in terms of filling blocks up and having chained rows.

Jon

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