From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Documenting serializable vs snapshot isolation levels |
Date: | 2008-12-30 17:58:15 |
Message-ID: | 1230659895.4032.22.camel@ebony.2ndQuadrant |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 2008-12-29 at 18:13 -0600, Kevin Grittner wrote:
> I hope someone can show me something good I've missed so far.
You're viewing this in problem-exposed language, unintentionally I'm
sure. My viewpoint on this is that database concurrency is a big issue,
but that the way we do things round here is a major leap forward on the
way things happened previously (and still do in older-style DBMS).
Our approach to serializable queries is an optimistic one in two ways:
It covers most cases, but not all theoretical cases. It also avoids
locks by default.
Those are good things, with many benefits. If we put the default the
other way around, developers would spend much more time re-tuning
queries that had locked each other out. So I would say we choose to
avoid locking-on-every-query with good reason. Just look at the
facilities DB2 provides to avoid it. Ugh-ly.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2008-12-30 18:00:02 | Re: about truncate |
Previous Message | Kevin Grittner | 2008-12-30 17:28:01 | Re: incoherent view of serializable transactions |