Re: Exposing the Xact commit order to the user

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Exposing the Xact commit order to the user
Дата
Msg-id 201006011509.o51F96U24923@momjian.us
обсуждение исходный текст
Ответ на Re: Exposing the Xact commit order to the user  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: Exposing the Xact commit order to the user  (Jan Wieck <JanWieck@Yahoo.com>)
Список pgsql-hackers
Jan Wieck wrote:
> >> > I see no problem with integrating that into core, technically or
> >> > philosophically.
> >> > 
> >> 
> >> Which means that if I want to allow a consumer of that commit order data 
> >> to go offline for three days or so to replicate the 5 requested, low 
> >> volume tables, the origin needs to hang on to the entire WAL log from 
> >> all 100 other high volume tables?
> > 
> > I suggest writing an external tool that strips out what you need that
> > can be run at any time, rather than creating a new data format and
> > overhead for this usecase.
> > 
> 
> Stripping it out from what?

Stripping it from the WAL.  Your system seems to require double-writes
on a commit, which is something we have avoided in the past.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + None of us is going to be here forever. +


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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Exposing the Xact commit order to the user
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: dividing money by money