fill factor guestimate

From: Dave Thompson <dthomp325(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: fill factor guestimate
Date: 2011-06-19 00:12:37
Message-ID: BANLkTimZRbSXg2xKkLSywYxLE9yr9DaAQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a table that will be updated frequently. Each row will be
updated at least once during it's lifetime, and most rows will be
updated ~10 times in their first 2 weeks of existence, and then
relatively rarely after that. The rows are being updated by a prepared
statement that gets executed with ~100 - ~600 different parameter
sets, each one updating a single row. What should my initial
best-guess fill-factor for the table be? Most of the updates don't
touch an indexed column, so I'm hoping to take advantage of the HOT
update feature. Will EXPLAIN tell me if an UPDATE uses HOT?

thanks
-Dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message lover boi 2011-06-19 02:27:23 Referencing function value inside CASE..WHEN
Previous Message David Johnston 2011-06-18 22:39:48 Re: Search for lists