Re: Exposing the Xact commit order to the user - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Exposing the Xact commit order to the user
Date
Msg-id 201006011509.o51F96U24923@momjian.us
Whole thread Raw
In response to Re: Exposing the Xact commit order to the user  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Exposing the Xact commit order to the user  (Jan Wieck <JanWieck@Yahoo.com>)
List 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 by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Exposing the Xact commit order to the user
Next
From: "Kevin Grittner"
Date:
Subject: Re: dividing money by money