Hi, I would like to propose a patch that adds memory usage reporting to VACUUM VERBOSE output. This helps users understand how much memory is being used for dead tuple tracking and whether memory limits are being hit during vacuum operations.
I have tested this patch with both serial and parallel VACUUM: - Serial VACUUM with two maintenance_work_mem settings - Parallel VACUUM with two maintenance_work_mem settings - Cases with and without memory resets Test cases are included showing: 1. Reset behavior with constrained memory (64KB) 2. No reset behavior with ample memory (64MB) 3. Both serial and parallel VACUUM scenarios I look forward to your feedback. Best regards, Tatsuya Kawata
test_memory_tracking.sql
Description: Binary data
0001-Add-memory-usage-reporting-to-VACUUM-VERBOSE.patch
Description: Binary data
