ok.. But we have set fill_factor = 80 for all the indexes on table1. Is there a way to check if the page is fill and the update is going on a new page ??
On Wed, Jul 2, 2008 at 6:59 PM, Jonah H. Harris <[EMAIL PROTECTED]> wrote: > On Wed, Jul 2, 2008 at 9:11 AM, Gauri Kanekar > <[EMAIL PROTECTED]> wrote: > > hot have a limitation that it do not work if, the index column is > updated. > > But that not the case over here. > > Another limitation is that HOT won't work if there's not enough space > to fit the update on the same page. > > -- > Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 > EnterpriseDB Corporation | fax: 732.331.1301 > 499 Thornall Street, 2nd Floor | [EMAIL PROTECTED] > Edison, NJ 08837 | http://www.enterprisedb.com/ > -- Regards Gauri
