Re: Fwd: Clarification about HOT
| От | Pavan Deolasee |
|---|---|
| Тема | Re: Fwd: Clarification about HOT |
| Дата | |
| Msg-id | 2e78013d0711050646s26df5ca9j10f2c070fc76af42@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Fwd: Clarification about HOT ("Gokulakannan Somasundaram" <gokul007@gmail.com>) |
| Ответы |
Re: Fwd: Clarification about HOT
|
| Список | pgsql-hackers |
On Nov 5, 2007 8:04 PM, Gokulakannan Somasundaram <gokul007@gmail.com> wrote:
There may not be anything called chain-pruning. Instead the tuples, which are to be vacuumed, will get vacuumed, after redirecting their index tuple peers, during the Vacuum process.
This won't help us check the heap bloat. Though containing index bloat is important,
most of the performance benefits of HOT comes from doing page level retail vacuuming.
This not only reduces the heap bloat but also results in less frequent vacuuming
of the table.
Thanks,
Pavan
--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: