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 463748.5349.qm@web31811.mail.mud.yahoo.com
Whole thread Raw
In response to Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER  ("Gregory Williamson" <Gregory.Williamson@digitalglobe.com>)
Responses Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
List pgsql-general
--- Gregory Williamson <Gregory.Williamson@digitalglobe.com> wrote:

> A very low fill factor means that pages are
> "sparse" and so inserts and updates are less likely to trigger massive b-tree rebalancings.

I take it that "massive b-tree rebalancings" could cause a problem with the performance of disk
writing though-put from UPDATEs and INSERTs?

Regards,
Richard Broersma Jr.

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Windows Auto-Vacuum in 8.2.4 or 8.2.5
Next
From: Greg Williamson
Date:
Subject: Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER