On Tue, Apr 29, 2008 at 6:42 PM, Gauri Kanekar <[EMAIL PROTECTED]> wrote: > Thats how our updates works. > We usually tend to touch the same row many times a day. >
Then start with a non-100 fillfactor. I would suggest something like 80 and then adjust based on the testing. Since you are anyways have a update intensive setup, leaving free space in the heap won't harm you much in the long term. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
