44 messages in org.postgresql.pgsql-hackersRe: New feature request: FlashBack Query| From | Sent On | Attachments |
|---|---|---|
| RPK | Feb 17, 2007 6:49 am | |
| Joshua D. Drake | Feb 17, 2007 7:50 am | |
| Tom Lane | Feb 17, 2007 8:48 am | |
| elein | Feb 17, 2007 4:06 pm | |
| Chad Wagner | Feb 17, 2007 4:43 pm | |
| Joshua D. Drake | Feb 17, 2007 7:21 pm | |
| Chad Wagner | Feb 17, 2007 7:49 pm | |
| Tom Lane | Feb 17, 2007 9:31 pm | |
| Warren Turkal | Feb 17, 2007 10:46 pm | |
| Hannu Krosing | Feb 18, 2007 1:45 pm | |
| Joshua D. Drake | Feb 18, 2007 2:27 pm | |
| Andreas 'ads' Scherbaum | Feb 19, 2007 1:53 am | |
| Hannu Krosing | Feb 19, 2007 4:36 am | |
| Florian G. Pflug | Feb 19, 2007 6:13 am | |
| Alvaro Herrera | Feb 19, 2007 6:27 am | |
| Zeugswetter Andreas ADI SD | Feb 19, 2007 6:32 am | |
| Zeugswetter Andreas ADI SD | Feb 19, 2007 6:38 am | |
| Florian G. Pflug | Feb 19, 2007 6:59 am | |
| Gregory Stark | Feb 19, 2007 7:18 am | |
| tom...@tuxteam.de | Feb 19, 2007 8:18 am | |
| August Zajonc | Feb 19, 2007 10:09 am | |
| Florian G. Pflug | Feb 19, 2007 11:30 am | |
| August Zajonc | Feb 19, 2007 12:00 pm | |
| Tom Lane | Feb 19, 2007 7:39 pm | |
| Jonah H. Harris | Feb 19, 2007 8:53 pm | |
| Gregory Stark | Feb 20, 2007 12:58 am | |
| RPK | Feb 20, 2007 3:25 am | |
| Andrew Dunstan | Feb 20, 2007 4:42 am | |
| Jonah H. Harris | Feb 20, 2007 7:19 am | |
| Rod Taylor | Feb 20, 2007 7:42 am | |
| Hannu Krosing | Feb 20, 2007 8:02 am | |
| Gregory Stark | Feb 20, 2007 8:28 am | |
| August Zajonc | Feb 20, 2007 8:39 am | |
| RPK | Feb 20, 2007 10:27 am | |
| Tom Lane | Feb 20, 2007 10:40 am | |
| Theo Schlossnagle | Feb 20, 2007 10:45 am | |
| Jonah H. Harris | Feb 20, 2007 11:48 am | |
| Jonah H. Harris | Feb 20, 2007 12:03 pm | |
| August Zajonc | Feb 20, 2007 7:30 pm | |
| Csaba Nagy | Feb 21, 2007 1:17 am | |
| Florian G. Pflug | Feb 21, 2007 6:01 am | |
| Alvaro Herrera | Feb 21, 2007 6:13 am | |
| Florian G. Pflug | Feb 21, 2007 7:08 am | |
| August Zajonc | Mar 1, 2007 9:48 am |
| Subject: | Re: New feature request: FlashBack Query | |
|---|---|---|
| From: | Rod Taylor (rod....@gmail.com) | |
| Date: | Feb 20, 2007 7:42:05 am | |
| List: | org.postgresql.pgsql-hackers | |
Wrong. When Oracle says it's committed, it's committed. No difference between when, where, and how. In Oracle, the committed version is *always* the first presented to the user... it takes time to go back and look at older versions; but why shouldn't that be a bit slower, it isn't common practice anyway. Same with rollbacks... why should they optimize for them when 97% of transactions commit?
Do 97% of transactions commit because Oracle has slow rollbacks and developers are working around that performance issue, or because they really commit?
I have watched several developers that would prefer to issue numerous selects to verify things like foreign keys in the application in order to avoid a rollback.
Anyway, I don't have experience with big Oracle applications but I'm not so sure that 97% of transactions would commit if rollbacks were cheaper.