From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Cc:
Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>,
Gregory Stark <stark(at)enterprisedb(dot)com>,
Emmanuel Cecchet <manu(at)frogthinker(dot)org>,
"pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject:
Re: incoherent view of serializable transactions
Date:
2008-12-24 23:53:35
Message-ID:
EF51FA30-452A-44C8-835F-DB55C95A72CD@gmail.com (view raw or flat )
Thread:
2008-12-22 17:00:53 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-22 17:54:59 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2008-12-22 18:37:45 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 04:44:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-12-23 14:51:03 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 14:59:30 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-12-23 15:14:36 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 15:47:37 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2008-12-23 16:10:05 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 20:55:47 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-12-23 21:11:00 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-31 00:33:26 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-01-03 22:06:14 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-01-03 22:53:51 from Gregory Stark <stark(at)enterprisedb(dot)com>
2009-01-03 23:37:09 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-01-05 14:51:29 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-01-07 13:17:49 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-01-07 15:40:02 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-01-08 14:45:25 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-01-22 03:00:16 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 16:12:09 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-12-23 16:27:57 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 17:04:11 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-12-23 17:24:51 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 17:15:38 from Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
2008-12-23 17:58:29 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 20:46:39 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-12-23 21:06:01 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-24 23:46:17 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2008-12-24 23:53:35 from Robert Haas <robertmhaas(at)gmail(dot)com>
2008-12-29 12:20:34 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2008-12-29 15:16:42 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-29 15:27:51 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-29 17:21:12 from Greg Stark <greg(dot)stark(at)enterprisedb(dot)com>
2008-12-30 08:56:43 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2008-12-30 17:28:01 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-01-03 22:20:10 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2008-12-23 05:42:06 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-12-23 18:48:52 from Jeff Davis <pgsql(at)j-davis(dot)com>
2008-12-23 23:44:53 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
Lists:
pgsql-hackers
On Dec 24, 2008, at 6:46 PM, Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
wrote:
> Robert Haas wrote:
>>> ... serializable transaction ...
>> If we were to construct a database that had one giant lock for the
>> entire database so that only a single query could execute at one
>> time,
>> transactions would be serializable (because they'd in fact be
>> serialized). However, performance would suck.
>
> I wonder if this giant-lock-for-isolation-level-serializable
> is a mode postgres should support. ISTM it would meet the
> letter of the spec, and at least some of the people using
> "transaction isolation level serializable" are doing so precisely
> because they *want* the database to deal with all possible
> serialization issues, and accepting performance penalties.
No. :-)
Cheers,
...Robert
In response to
pgsql-hackers by date
Next :From: KaiGai KoheiDate: 2008-12-25 00:05:07Subject : Re: [idea] a copied relkind in pg_attributePrevious :From : Ron MayerDate : 2008-12-24 23:46:17Subject : Re: incoherent view of serializable transactions
