Please keep list in the loop. On Wed, Apr 30, 2008 at 6:45 PM, Gauri Kanekar <[EMAIL PROTECTED]> wrote: > Hi, > We have recreated the indices with fillfactor set to 80, which has improved > HOT > a little,
Wait. Did you say, you recreated the indexes with fill factor ? That's no help for HOT. You need to recreate the TABLEs with a fill factor. And as Heikki pointed out, you need to dump and reload, just altering the table won't affect the current data. 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
