Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>, Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Date: 2007-09-18 16:29:25
Message-ID: 679465.17856.qm@web31809.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo De León 2007-09-18 16:31:21 Re: ON INSERT => execute AWK/SH/EXE?
Previous Message Bill Moran 2007-09-18 16:29:14 index fillfactor (was Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER)