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

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Gregory Williamson <Gregory(dot)Williamson(at)digitalglobe(dot)com>, 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 19:17:03
Message-ID: 463748.5349.qm@web31811.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


--- Gregory Williamson <Gregory(dot)Williamson(at)digitalglobe(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Williamson 2007-09-18 19:20:26 Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Previous Message Richard Broersma Jr 2007-09-18 19:08:39 Windows Auto-Vacuum in 8.2.4 or 8.2.5