Hi All,

The version 4.0 of HOT patch is very close to the state where
we can start considering it for testing for correctness as well
as benchmarking, if there is sufficient interest to give it a
chance for 8.3

I have very little clue about what community thinks about
HOT and the patch, but I am ready to do whatever it needs
to increase quality of the patch. But I need reviews and
feedback to do that.

IMHO there are two things that need to be done to make HOT
feature complete. They are,

- Support for VACUUM FULL
- Support for CREATE INDEX

Simon has interest working on these items. I have
some ideas for supporting CREATE INDEX, but would wait
for Simon's thoughts on this.

Then there are several optimization and tuning work that
needs to be done. I am planning to start work on the following
two items and need suggestions/comments to make sure that
I am following the right path:

- With Tom/Heikki's recent patch of tracking free line pointers,
 we have some bits available in the page header for book-keeping.
 I plan to use one bit to track if there are any LP_DELETEd items
 on the page. This information would help us to quickly check
 if its worth searching through the line pointers to find a
 LP_DELETED item. The flag will be set whenever a tuple is marked
 LP_DELETEd and reset in page-VACUUM and whenever we fail to
 find a LP_DELETEd item for reuse.

- Another problem with the current HOT patch is that it generates
 tuple level fragmentation while reusing LP_DELETEd items when
 the new tuple is of smaller size than the original one. Heikki
 supported using best-fit strategy to reduce the fragmentation
 and thats worth trying. But ISTM that we can also correct
 row-level defragmentation whenever we run out of free space
 and LP_DELETEd tuples while doing UPDATE. Since this does not
 require moving tuples around, we can do this by a simple EXCLUSIVE
 lock on the page. A bit to track row-level fragmentation would

These would be just hint-bits and changes need not be WAL logged.
We could have done better with some sort of counters, but that
would require heap-page specific data and that may not
necessarily be a good idea.

Comments ?


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to