Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Date
Msg-id 679465.17856.qm@web31809.mail.mud.yahoo.com
Whole thread Raw
In response to Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
List pgsql-general
--- Phoenix Kiula <phoenix.kiula@gmail.com> wrote:

> What constitutes a "small fill factor"? Would 70 be good? I guess my
> current must have been the default, which the manual says is 100.

On the following link:

http://www.postgresql.org/docs/8.2/interactive/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS

I found this:

"B-trees use a default fillfactor of 90, but any value from 10 to 100 can be selected."

Regards,
Richard Broersma Jr.

pgsql-general by date:

Previous
From: Jeff Ross
Date:
Subject: Re: Alter sequence restart with selected value...
Next
From: Bill Moran
Date:
Subject: index fillfactor (was Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER)