Re: Hot Issue
| От | Gauri Kanekar |
|---|---|
| Тема | Re: Hot Issue |
| Дата | |
| Msg-id | 7e4ba9550807020644j4f41530axd43317c7f180faed@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Hot Issue ("Jonah H. Harris" <jonah.harris@gmail.com>) |
| Ответы |
Re: Hot Issue
|
| Список | pgsql-performance |
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 ??
--
Regards
Gauri
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@gmail.com> wrote:
On Wed, Jul 2, 2008 at 9:11 AM, Gauri KanekarAnother limitation is that HOT won't work if there's not enough space
<meetgaurikanekar@gmail.com> wrote:
> hot have a limitation that it do not work if, the index column is updated.
> But that not the case over here.
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@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/
--
Regards
Gauri
В списке pgsql-performance по дате отправления: