From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
---|---|
To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
Subject: | Re: tracking commit timestamps |
Date: | 2014-11-11 17:13:13 |
Message-ID: | 20141111171313.GK18565@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-www |
On 2014-11-11 17:09:54 +0000, Simon Riggs wrote:
> On 11 November 2014 16:19, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> > On 2014-11-11 16:10:47 +0000, Simon Riggs wrote:
> >> On 4 November 2014 08:23, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> >>
> >> >> 6) Shouldn't any value update of track_commit_timestamp be tracked in
> >> >> XLogReportParameters? That's thinking about making the commit timestamp
> >> >> available on standbys as well..
> >> >
> >> > Yes, it should.
> >>
> >> Agree committs should be able to run on standby, but it seems possible
> >> to do that without it running on the master.
> >
> > I don't think that's realistic. It requires WAL to be written in some
> > cases, so that's not going to work. I also don't think it's a
> > particularly interesting ability?
>
> OK, so we are saying commit timestamp will NOT be available on Standbys.
Hm? They should be available - xact.c WAL replay will redo the setting
of the timestamps and explicitly overwritten timestamps will generate
their own WAL records. What I mean is just that you can't use commit
timestamps without also using it on the primary.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-11-11 19:31:39 | Re: Column/type dependency recording inconsistencies |
Previous Message | Simon Riggs | 2014-11-11 17:09:54 | Re: tracking commit timestamps |
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2014-11-11 19:51:40 | Re: tracking commit timestamps |
Previous Message | Simon Riggs | 2014-11-11 17:09:54 | Re: tracking commit timestamps |