On Wed, Jul 2, 2008 at 9:44 AM, Gauri Kanekar <meetgaurikanekar@xxxxxxxxx> wrote: > ok.. But we have set fill_factor = 80 for all the indexes on table1. You need fill factor for the heap table, not the index. > Is there a way to check if the page is fill and the update is going on a new > page ?? IIRC, I don't think so. I think you'd have to u se something like pg_filedump to see if you have rows migrated to other blocks due to updates. -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@xxxxxxxxxxxxxxxx Edison, NJ 08837 | http://www.enterprisedb.com/
