Postgres Pro
Downloads
Home   >   mailing lists

Re: [TODO] Track number of files ready to be archived in pg_stat_archiver - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [TODO] Track number of files ready to be archived in pg_stat_archiver
Date
Msg-id CA+U5nM+T5piBeOHoSp_GmZ7g1+WC-BcCQ+y3srXScGeR_OCjqQ@mail.gmail.com
Whole thread Raw
In response to [TODO] Track number of files ready to be archived in pg_stat_archiver  (Julien Rouhaud <julien.rouhaud@dalibo.com>)
Responses Re: [TODO] Track number of files ready to be archived in pg_stat_archiver  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Tree view 
On 21 August 2014 09:17, Julien Rouhaud <julien.rouhaud@dalibo.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

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Next
From: Alvaro Herrera
Date:
Subject: Re: Turning off HOT/Cleanup sometimes