Hello, >Your current design completely misses the time taken to scan indexes, which is significant. I tried to address this issue in the attached patch. The patch calculates index scan progress by measuring against scanned pages in LVRelStats. It checks for a change current page being scanned and increments the progress counter. When counter reaches scanned pages number in LVRelStats, progress is 100% complete. For now the progress is emitted as a warning (so no config changes needed to see progress) Thoughts? regards Sameer IndexScanProgress.patch <http://postgresql.nabble.com/file/n5858109/IndexScanProgress.patch>
-- View this message in context: http://postgresql.nabble.com/PROPOSAL-VACUUM-Progress-Checker-tp5855849p5858109.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers