Re: A couple thoughts about btree fillfactor

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mark(at)mark(dot)mielke(dot)cc
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: A couple thoughts about btree fillfactor
Date: 2006-07-10 19:17:01
Message-ID: 23878.1152559021@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

mark(at)mark(dot)mielke(dot)cc writes:
> ... Do you think there should be a way of packing certain
> indexes tighter, once they are known to be mostly read only? For
> example, an option on REINDEX? This would free PostgreSQL to use a
> smaller fillfactor while still allowing people to optimize those of
> their tables that would benefit from a higher fillfactor once they
> become mostly static?

Isn't it sufficient to change the fillfactor and REINDEX?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Phil Frost 2006-07-10 19:18:28 Re: lastval exposes information that currval does not
Previous Message Stefan Kaltenbrunner 2006-07-10 19:14:08 Re: Removing AddDepends; should I bother with a project?