From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: WAL logging of SELECT ... INTO command |
Date: | 2006-03-22 15:35:26 |
Message-ID: | 16692.1143041726@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches pgsql-performance |
"Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> Oh, so in other words, SELECT * INTO temp FROM table is inherently
> non-deterministic at the physical level, so the only way to be able to
> allow PITR to work is to duplicate all the physical changes. Darn.
Well, lemme put it this way: I'm not prepared to require that PG be
deterministic at the physical level. One obvious source of
non-determinancy is the FSM, which is likely to hand out different free
space to different transactions depending on what else is going on at
the same time. There are others, such as deliberately random
tie-breaking during btree index insertion.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Wong | 2006-03-22 15:52:32 | Re: Patch Submission Guidelines |
Previous Message | Jim C. Nasby | 2006-03-22 15:14:34 | Re: WAL logging of SELECT ... INTO command |
From | Date | Subject | |
---|---|---|---|
Next Message | PFC | 2006-03-22 16:07:52 | Re: Massive Inserts Strategies |
Previous Message | ashah | 2006-03-22 15:32:10 | Massive Inserts Strategies |