Hi, I know this might already be late at end of CommitFest, but attached is the latest version of the patch. The previous version only includes buffer invalidation improvement for VACUUM. The new patch adds the same routine for TRUNCATE WAL replay.
In summary, this patch aims to improve the buffer invalidation process of VACUUM and TRUNCATE. Although it may not be a common use case, our customer uses these commands a lot. Recovery and WAL replay of these commands can take time depending on the size of database buffers. So this patch optimizes that using the newly-added auxiliary cache and doubly-linked list on the shared memory, so that we don't need to scan the shared buffers anymore. As for the performance and how it affects the read-only workloads. Using pgbench, I've kept the overload to a minimum, less than 1%. I'll post follow-up results. Although the additional hash table utilizes shared memory, there's a significant performance gain for both TRUNCATE and VACUUM from execution to recovery. Regards, Kirk Jamison
v7-Optimize-dropping-of-relation-buffers-using-dlist.patch
Description: v7-Optimize-dropping-of-relation-buffers-using-dlist.patch
