Re: A couple thoughts about btree fillfactor - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A couple thoughts about btree fillfactor
Date
Msg-id 23878.1152559021@sss.pgh.pa.us
Whole thread Raw
In response to Re: A couple thoughts about btree fillfactor  (mark@mark.mielke.cc)
List pgsql-hackers
mark@mark.mielke.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


pgsql-hackers by date:

Previous
From: Tzahi Fadida
Date:
Subject: CTIDs invalidations and dropping columns.
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: Removing AddDepends; should I bother with a project?