GUC for default heap fillfactor

From: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: GUC for default heap fillfactor
Date: 2007-08-08 12:35:06
Message-ID: 2e78013d0708080535o6ed0919duc85edd0f1d63ac15@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

If HOT gets into 8.3, we might need a GUC to set database wide heap
fillfactor to an appropriate value. The only way to so today is compile
time value of DEFAULT_HEAP_FILLFACTOR. HOT works much
better if there is atleast one tuple worth of free space in each block.
Otherwise atleast the first UPDATE in each block would be a COLD
update.

Should we consider adding such a GUC now ? I searched through
archives, but did not find any strong objection to doing so in the past.
But I might have missed something. Comments ?

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Foster 2007-08-08 13:00:15 Postgresql service account issue!?
Previous Message Bertram Scharpf 2007-08-08 12:04:23 Re: Wrote a connect-by feature