Enhancing update performance by avoiding index modification when the updated column isn't part of any index. This relies heavily on "Page Pruning" to clean up dead tuples on the fly without a full VACUUM.
This is the difference between a database that scales and one that chokes on write amplification.
Check out the book: https://dub.sh/RNV0WzR And join the upcoming event: https://dub.sh/S0Vsj3W
#Postgresql #Internals #HOTUpdates