Re: Cache lookup failed for relation

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: David Clymer <david(dot)clymer(at)vistashare(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cache lookup failed for relation
Date: 2013-02-11 18:50:14
Message-ID: 1360608614.96665.YahooMailNeo@web162904.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Clymer <david(dot)clymer(at)vistashare(dot)com> wrote:

> The SERIALIZABLE isolation mode is being used in 9.0, and
> REPEATABLE READ in 9.2, which should be the same thing, correct
> (eg. 9.0 serializable ~ 9.2 repeatable read)?

Correct.

In 9.0 SERIALIZABLE and REPEATABLE READ are exactly same.  In 9.1
and later REPEATABLE READ has not changed from 9.0, but
SERIALIZABLE has basically become REPEATABLE READ with extra
checking for serialization failures.

-Kevin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2013-02-11 19:17:03 Re: fascinating article on postgresql mailing lists
Previous Message Pavel Stehule 2013-02-11 18:22:15 Re: Cache lookup failed for relation