Re: Hot Issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <jonah.harris@xxxxxxxxx> wrote:
On Wed, Jul 2, 2008 at 9:11 AM, Gauri Kanekar
<meetgaurikanekar@xxxxxxxxx> 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 | jonah.harris@xxxxxxxxxxxxxxxx
Edison, NJ 08837 | http://www.enterprisedb.com/



--
Regards
Gauri

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux