Reusing Dead Tuples:
От | Janardhan |
---|---|
Тема | Reusing Dead Tuples: |
Дата | |
Msg-id | 3DF6A5DB.4090207@mediaring.com.sg обсуждение исходный текст |
Ответы |
Re: Reusing Dead Tuples:
|
Список | pgsql-hackers |
Hi, I am doing some experiments on dead tuples, I am looking of reusing the dead tuples apace in a particular page during the "Update".This patch is meant for the tables which are heavily updated to avoid vacuum very frequently.By using it will arrest the size of table for heavily updated table. The algorithm works like this:1) During the update it check for the dead tuples in the current page(page that containthe tuple that need to be updated). If it finds any dead tuples it uses the dead tuple spaceby ovewriting on dead tuple. The checking of dead tuple is very similer to the task that of lazy vaccum.2) If it cannot find any dead tuple it proceed as usual by inserting at the end of table . Performance Effect: 1) The CPU processing will be slighly more for the update, but io processing is exactly same2) The size of table grows slower under heavy update , so vacuum is not required very frequently. The total processing for update is more or less same even after doing large number of updates without vacuum. Does it breaks anythings by overwriting the dead tuples ?. Comments?. jana
В списке pgsql-hackers по дате отправления: