From: | "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com> |
---|---|
To: | "pgsql-hackers list" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Requesting clarification on Vacuuming/Freezing behaviour |
Date: | 2007-12-17 07:47:21 |
Message-ID: | 9362e74e0712162347g65ef8165wbe5dc6fd514539ff@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I got some time to relook at the index with the snapshot patch. Still i
need to complete the freezing of index tuples with the snapshot.
a) When i was looking at the code for freezing heap tuples, i found out the
following. While freezing we log the complete block(not just the tuples we
froze).
b) Again after removing the dead tuples and fragmentation, we log the
complete block.
As i understand, Vacuum is one atomic operation. Why do we need to make this
extra protection for Freezing?
I think the fix should be very simple. Before logging the Frozen block, we
need to check whether there are any dead tuples removed from it..
Please clarify on whether i am missing something important..
--
Thanks,
Gokul.
CertoSQL Project,
Allied Solution Group.
(www.alliedgroups.com)
From | Date | Subject | |
---|---|---|---|
Next Message | Gokulakannan Somasundaram | 2007-12-17 08:02:54 | Re: Proposal for Null Bitmap Optimization(for Trailing NULLs) |
Previous Message | Gokulakannan Somasundaram | 2007-12-17 07:40:48 | Proposal for Null Bitmap Optimization(for Trailing NULLs) |