On Nov 5, 2007 7:37 PM, Gokulakannan Somasundaram <[EMAIL PROTECTED]> wrote:
> Tom, > Let me try to understand your statement. > > What extra multi-page operations are we doing? > Currently, during Vacuum, we goto the Index and mark it as dead and > reclaim the space. For doing this, we are acquiring a Super-Exclusive lock. > After this implementation, we would update the index tuple instead of > marking it for cleanup. What can be foreseen as a locking overhead here? > > > Its not just about vacuuming. You need to worry about locking during the HOT-fetches as well as chain pruning. There could be tricky corner cases between index/seq scans and pruning. And don't forget CREATE INDEX which would become even more challenging if you have HOT chains spanning multiple pages. This is not to discourage you from trying to improve HOT. But once-upon-a-time we had this multi-page HOT (it was called Heap-Overflow-Tuple) and I can tell you: it was really complex. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com