On Sat, 2010-08-07 at 16:11 -0700, Gordon Shannon wrote:
> So, I guess my real question here is, what happened to the "missing"
> 100 items? If it was HOT prune, can anyone summarize what that does?
Itagaki already explained that the second DELETE would have removed the
100 dead rows you consider to be missing.
Any SQL statement that reads a block can do HOT pruning, if the block is
otherwise unlocked.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services