Re: Core team statement on replication in PostgreSQL - Mailing list pgsql-hackers

From Marko Kreen
Subject Re: Core team statement on replication in PostgreSQL
Date
Msg-id e51f66da0805291222w5a0928ebk3d96dfe5bd713c0a@mail.gmail.com
Whole thread Raw
In response to Re: Core team statement on replication in PostgreSQL  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers
On 5/29/08, Teodor Sigaev <teodor@sigaev.ru> 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


pgsql-hackers by date:

Previous
From: Brian Hurt
Date:
Subject: Re: Core team statement on replication in PostgreSQL
Next
From: Andrew Sullivan
Date:
Subject: Re: Core team statement on replication in PostgreSQL