"Right, the improvement this patch gives to the heap is not the full motivation. Another motivation is the improvement
itgives to TableAM API. Our current API implies that the effort on locating the tuple by tid is small. This is more or
lesstrue for the heap, where we just need to pin and lock the buffer. But imagine other TableAM implementations, where
locatinga tuple is more expensive."
Yeah. Our TableAM API is a very nice start to getting pluggable storage, but we still have a long ways to go to have an
abilityto really provide a wide variety of pluggable storage engines.
In particular, the following approaches are likely to have much more expensive tid lookups:
- columnar storage (may require a lot of random IO to reconstruct a tuple)
- index oriented storage (tid no longer physically locatable in the file via seek)
- compressed cold storage like pg_ctyogen (again seek may be problematic).
To my mind I think the performance benefits are a nice side benefit, but the main interest I have on this is regarding
improvementsin the TableAM capabilities. I cannot see how to do this without a lot more infrastructure.