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: | Jonah H. Harris (jona...@gmail.com) | |
| Date: | Feb 20, 2007 11:48:21 am | |
| List: | org.postgresql.pgsql-hackers | |
On 2/20/07, Rod Taylor <rod....@gmail.com> wrote:
Do 97% of transactions commit because Oracle has slow rollbacks and developers are working around that performance issue, or because they really commit?
Again, off-topic, but 97% of all transactions commit according to Jim Gray and his research... not anything related to Oracle.
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.
That's just bad development.
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.
Again, stats not related to Oracle, but databases in general.
-- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 3rd Floor | jhar...@enterprisedb.com Iselin, New Jersey 08830 | http://www.enterprisedb.com/