On 2023-May-13, John Naylor wrote: > -------------------- > 2. Propose to move to the "Not Wanted list":
> Consider having single-page pruning update the visibility map > -> Comment from Heikki in the thread: > "I think I was worried about the possible performance impact of having to > clear the bit in visibility map again. If you're frequently updating a > tuple so that HOT and page pruning is helping you, setting the bit in > visibility map seems counter-productive; it's going to be cleared soon > again by another UPDATE. That's just a hunch, though. Maybe the overhead > is negligible." Hmm, I agree with removing the entry from the TODO list, but why is this something we Do Not Want? If somebody shows up and do some analysis that in a certain workload it is beneficial to do this, then I don't think we should turn them down. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/