| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [TODO] Track number of files ready to be archived in pg_stat_archiver |
| Date: | 2014-11-17 20:47:37 |
| Message-ID: | CA+U5nM+T5piBeOHoSp_GmZ7g1+WC-BcCQ+y3srXScGeR_OCjqQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 21 August 2014 09:17, Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com> wrote:
> Track number of WAL files ready to be archived in pg_stat_archiver
Would it be OK to ask what the purpose of this TODO item is?
pg_stat_archiver already has a column for last_archived_wal and
last_failed_wal, so you can already work out how many files there must
be between then and now. Perhaps that can be added directly to the
view, to assist the user in calculating it. Reading the directory
itself to count the file is unnecessary, except as a diagnostic.
Please don't take "it is a TODO item" as "generally accepeted that
this makes sense".
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2014-11-17 21:09:07 | Re: Turning off HOT/Cleanup sometimes |
| Previous Message | Peter Geoghegan | 2014-11-17 20:04:33 | Re: Doing better at HINTing an appropriate column within errorMissingColumn() |