On 17 October 2014 12:52, Amit Kapila <amit.kapila16@gmail.com> wrote:
> It is quite possible, but still I think to accomplish such a function,
> we need to have some mechanism where it can inform auto vacuum
> and then some changes in auto vacuum to receive/read that information
> and reply back. I don't think any such mechanism exists.
That's exactly how the CHECKPOINT command works, in conjunction with
the checkpointer process.
-- Simon Riggs http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services