| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Petr Jelinek <petr(at)2ndquadrant(dot)com> |
| Cc: | 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-10-28 12:25:37 |
| Message-ID: | CA+U5nML2+cHokZURpfd+mMaN8pR2bLSTpx9BFY=wpx7YRW02tg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-www |
On 13 October 2014 10:05, Petr Jelinek <petr(at)2ndquadrant(dot)com> wrote:
>> I worked bit on this patch to make it closer to committable state.
> Here is updated version that works with current HEAD for the October
> committfest.
I've reviewed this and it looks good to me. Clean, follows existing
code neatly, documented and tested.
Please could you document a few things
* ExtendCommitTS() works only because commit_ts_enabled can only be
set at server start.
We need that documented so somebody doesn't make it more easily
enabled and break something.
(Could we make it enabled at next checkpoint or similar?)
* The SLRU tracks timestamps of both xids and subxids. We need to
document that it does this because Subtrans SLRU is not persistent. If
we made Subtrans persistent we might need to store only the top level
xid's commitTS, but that's very useful for typical use cases and
wouldn't save much time at commit.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2014-10-28 12:47:22 | Re: New Event Trigger: table_rewrite |
| Previous Message | Andres Freund | 2014-10-28 12:23:43 | Re: On partitioning |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2014-10-28 23:17:28 | Deal with <>s in message IDs |
| Previous Message | Magnus Hagander | 2014-10-27 09:40:39 | Re: PostgreSQL web development process (was: fix colspan of commitfest topic headers) |