Re: Expose checkpoint start/finish times into SQL.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 03 Apr 2008 21:26:46 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> > I would agree with this. We would need a history of checkpoints that
> > didn't reset until we told it to.
>
> Indeed, but the submitted patch has nought whatsoever to do with that.
> It exposes some instantaneous state.
>
> You could perhaps *build* a log facility on top of that, at the SQL
> level; but I don't see the point, and I definitely disagree that it
> would be "easier than trolling the logs".

Having the ability to do this:

SELECT * FROM pg_stat_bgwriter
WHERE last_checkpoint
BETWEEN (current_time - '1 Day'::interval) AND current_time;

Would be very useful. Which I can do with logs currently. You are
correct. However from a usability, remote reporting and manageability
perspective it certainly is not the same as something as I describe
above.

Note I am perfectly willing to table this until we have a full todo and
specification for a feature.

Sincerely,

Joshua D. Drake

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH9YVlATb/zqfZUUQRAnRxAKCab3O4dmBXctXTptDFwkRx+1zUQQCdFmsN
E3GWNoC90jS7ooFgArR8Nv0=
=CvMx
-----END PGP SIGNATURE-----