Re: Core team statement on replication in PostgreSQL

Поиск
Список
Период
Сортировка
От Marko Kreen
Тема Re: Core team statement on replication in PostgreSQL
Дата
Msg-id e51f66da0805291222w5a0928ebk3d96dfe5bd713c0a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Core team statement on replication in PostgreSQL  (Teodor Sigaev <teodor@sigaev.ru>)
Список 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 по дате отправления: