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

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: "Ow Mun Heng" <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Date: 2007-09-18 10:50:09
Message-ID: a55915760709180350u1a84d101vd4565a0abe851e10@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/18/07, Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> wrote:
> On Tue, 2007-09-18 at 06:01 -0400, Bill Moran wrote:
> > * (with newer version) reduce the fill factor and REINDEX
>
> What is fill factor?

See "Index Storage Parameters":
http://www.postgresql.org/docs/8.2/static/sql-createindex.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2007-09-18 10:52:01 Re: Recall: August Monthly techdata split fi
Previous Message Dániel Dénes 2007-09-18 10:22:22 Re: JOIN with ORDER on both tables does a sort when it souldn't