On 26 September 2012 15:47, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > > Really, as far as autovacuum is concerned, it would be much more useful > to be able to reliably detect that a table has been recently vacuumed, > without having to request a 10ms-recent pgstat snapshot. That would > greatly reduce the amount of time autovac spends on pgstat requests.
VACUUMing generates a relcache invalidation. Can we arrange for those invalidations to be received by autovac launcher, so it gets immediate feedback of recent activity without polling? -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers