Re: Core team statement on replication in PostgreSQL

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Core team statement on replication in PostgreSQL
Дата
Msg-id 483ED0A2.7060006@agliodbs.com
обсуждение исходный текст
Ответ на Re: Core team statement on replication in PostgreSQL  ("Marko Kreen" <markokr@gmail.com>)
Ответы Re: Core team statement on replication in PostgreSQL  (Bruce Momjian <bruce@momjian.us>)
Re: Core team statement on replication in PostgreSQL  (Aidan Van Dyk <aidan@highrise.ca>)
Список pgsql-hackers
Marko,

> But Tom's mail gave me impression core wants to wait until we get "perfect"
> read-only slave implementation so we wait with it until 8.6, which does
> not seem sensible.  If we can do slightly inefficient (but simple)
> implementation
> right now, I see no reason to reject it, we can always improve it later.

That's incorrect.  We're looking for a workable solution.  If we could 
get one for 8.4, that would be brilliant but we think it's going to be 
harder than that.

Publishing the XIDs back to the master is one possibility.  We also 
looked at using "spillover segments" for vacuumed rows, but that seemed 
even less viable.

I'm also thinking, for *async replication*, that we could simply halt 
replication on the slave whenever a transaction passes minxid on the 
master.  However, the main focus will be on synchrounous hot standby.

--Josh



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Justin
Дата:
Сообщение: Re: [PERFORM] Memory question on win32 systems
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: [PERFORM] Memory question on win32 systems