Re: Commits 8de72b and 5457a1 (COPY FREEZE)
Noah Misch <noah@leadboat.com>
From: Noah Misch <noah@leadboat.com>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Date: 2012-12-22T02:35:58Z
Lists: pgsql-hackers
On Sat, Dec 22, 2012 at 12:42:43AM +0000, Simon Riggs wrote: > On 21 December 2012 20:10, Noah Misch <noah@leadboat.com> wrote: > > I thought of one case where we do currently forget rd_newRelfilenodeSubid: > > > > BEGIN; > > TRUNCATE t; > > SAVEPOINT save; > > TRUNCATE t; > > ROLLBACK TO save; > > That's a weird one. Aborting a subtransacton that sets it, when it was > already set. > > The loss of rd_newRelfilenodeSubid in that case is deterministic, but > tracking the full complexity of multiple relations and multiple nested > subxids isn't worth the trouble for such rare cases [assumption]. > > I'd go for just setting an its_too_complex flag (with better name) > that we can use to trigger a message in COPY to say that FREEZE option > won't be honoured. That would then be completely consistent, rather > than the lack of deterministic behaviour that Robert rightly objects > to. I wouldn't bother. The behavior here is deterministic, the cause clearly traceable to the specific commands issued. Stable software won't suddenly miss the optimization for no visible reason.
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Keep rd_newRelfilenodeSubid across overflow.
- ae9aba69a860 9.3.0 cited
-
Reduce scope of changes for COPY FREEZE.
- 5457a130d3a6 9.3.0 cited
-
COPY FREEZE and mark committed on fresh tables.
- 8de72b66a2ed 9.3.0 cited