| From: | Sameer Thakur-2 <Sameer(dot)Thakur(at)nttdata(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [PROPOSAL] VACUUM Progress Checker. |
| Date: | 2015-07-16 04:30:10 |
| Message-ID: | 1437021010642-5858109.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2015-07-16 04:35:14 | Re: [PROPOSAL] VACUUM Progress Checker. |
| Previous Message | Fujii Masao | 2015-07-16 04:27:59 | Re: [PROPOSAL] VACUUM Progress Checker. |