"innovative Serializable Snapshot Isolation (SSI) level"

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

"innovative Serializable Snapshot Isolation (SSI) level"

PG Bug reporting form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/mvcc-intro.html
Description:

The documentation page:
__https://www.postgresql.org/docs/12/mvcc-intro.html
makes a reference to the term "innovative Serializable Snapshot Isolation
(SSI) level"
I can't find that anywhere in the documentation.  I am expecting to find it
here:
__https://www.postgresql.org/docs/12/transaction-iso.html
or here:
__https://www.postgresql.org/docs/current/sql-set-transaction.html
But there is nothing.

A search for the term "innovative Serializable Snapshot Isolation (SSI)
level":
__https://www.postgresql.org/search/?q=Serializable+Snapshot+Isolation+
produces a lengthy listing, demonstrating that the term is used throughout
the documentation.  But there is no entry in the documentation that defines
the term, or that defines the commands required to use it.

It is important to know:
a. if this is an ANSI/ISO/SQL Transaction Isolation Level
b. or if it is an extension
c. or if it is neither
d. how to use it
Reply | Threaded
Open this post in threaded view
|

Re: "innovative Serializable Snapshot Isolation (SSI) level"

Bruce Momjian
On Mon, Aug  3, 2020 at 01:41:24AM +0000, PG Doc comments form wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/12/mvcc-intro.html
> Description:
>
> The documentation page:
> __https://www.postgresql.org/docs/12/mvcc-intro.html
> makes a reference to the term "innovative Serializable Snapshot Isolation
> (SSI) level"
> I can't find that anywhere in the documentation.  I am expecting to find it
> here:
> __https://www.postgresql.org/docs/12/transaction-iso.html
> or here:
> __https://www.postgresql.org/docs/current/sql-set-transaction.html
> But there is nothing.
>
> A search for the term "innovative Serializable Snapshot Isolation (SSI)
> level":
> __https://www.postgresql.org/search/?q=Serializable+Snapshot+Isolation+
> produces a lengthy listing, demonstrating that the term is used throughout
> the documentation.  But there is no entry in the documentation that defines
> the term, or that defines the commands required to use it.

Uh, it is here:

        https://www.postgresql.org/docs/12/transaction-iso.html#XACT-SERIALIZABLE

"innovative" is not part of the name.

--
  Bruce Momjian  <[hidden email]>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee



Reply | Threaded
Open this post in threaded view
|

Re: "innovative Serializable Snapshot Isolation (SSI) level"

Thomas Munro-5
On Tue, Aug 4, 2020 at 10:24 AM Bruce Momjian <[hidden email]> wrote:

> On Mon, Aug  3, 2020 at 01:41:24AM +0000, PG Doc comments form wrote:
> > The following documentation comment has been logged on the website:
> >
> > Page: https://www.postgresql.org/docs/12/mvcc-intro.html
> > Description:
> >
> > The documentation page:
> > __https://www.postgresql.org/docs/12/mvcc-intro.html
> > makes a reference to the term "innovative Serializable Snapshot Isolation
> > (SSI) level"
> > I can't find that anywhere in the documentation.  I am expecting to find it
> > here:
> > __https://www.postgresql.org/docs/12/transaction-iso.html
> > or here:
> > __https://www.postgresql.org/docs/current/sql-set-transaction.html
> > But there is nothing.
> >
> > A search for the term "innovative Serializable Snapshot Isolation (SSI)
> > level":
> > __https://www.postgresql.org/search/?q=Serializable+Snapshot+Isolation+
> > produces a lengthy listing, demonstrating that the term is used throughout
> > the documentation.  But there is no entry in the documentation that defines
> > the term, or that defines the commands required to use it.
>
> Uh, it is here:
>
>         https://www.postgresql.org/docs/12/transaction-iso.html#XACT-SERIALIZABLE
>
> "innovative" is not part of the name.

Some more information was also recently added to provide references,
but it hasn't rolled out to the version 12 documentation website yet.
You can see it in the development version, though:

https://www.postgresql.org/docs/devel/transaction-iso.html

Here's the commit:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1575fbf1ac3c8464b2dade245deff537a3aa2498