On 5/29/08, Teodor Sigaev <
teodor@...> wrote:
> > in this case too. So each slave just needs to report its own longest
> > open tx as "open" to master. Yes, it bloats master but no way around it.
>
> Slaves should not report it every time or every transaction. Vacuum on
> master will ask them before doing a real work.
That is bit too slow if we want to do some page-level cleanup with
regular transactions / bgwriter. But once or twice per minute update
should work fine.
--
marko
--
Sent via pgsql-hackers mailing list (
pgsql-hackers@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
