Обсуждение: Tom Lane's presentation on SERIALIZABLE etc?

Hi,

I remember there used to be somewhere a link to a talk Tom gave (on
OSCON 2001 maybe?) on transaction processing, SERIALIZABLE, SELECT FOR
UPDATE, etc.  I'm pretty sure it was linked to somewhere in the old
developers page, but I cannot find it in the new one or elsewhere.  I
searched the OSCON site but it isn't showing up either.

This one is not it:
http://www.postgresql.org/files/developer/transactions.pdf
Transaction Processing in PostgreSQL

Any clues?

Thanks,

-- 
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"Estoy de acuerdo contigo en que la verdad absoluta no existe...
El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)

Alvaro Herrera <alvherre@commandprompt.com> writes:
> I remember there used to be somewhere a link to a talk Tom gave (on
> OSCON 2001 maybe?) on transaction processing, SERIALIZABLE, SELECT FOR
> UPDATE, etc.  I'm pretty sure it was linked to somewhere in the old
> developers page, but I cannot find it in the new one or elsewhere.  I
> searched the OSCON site but it isn't showing up either.

I think you mean

\Header{PostgreSQL Concurrency Issues}
\LFooter{Tom Lane}
\CFooter{O'Reilly Open Source Convention, July 2002}

I'm not sure where it is on the website either; there used to be a link
in the developer materials but it may be gone.  Anyway there's still a
PDF of the slides in my home directory on cvs.postgresql.org.
        regards, tom lane

Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > I remember there used to be somewhere a link to a talk Tom gave (on
> > OSCON 2001 maybe?) on transaction processing, SERIALIZABLE, SELECT FOR
> > UPDATE, etc.  I'm pretty sure it was linked to somewhere in the old
> > developers page, but I cannot find it in the new one or elsewhere.  I
> > searched the OSCON site but it isn't showing up either.
> 
> I think you mean
> 
> \Header{PostgreSQL Concurrency Issues}
> \LFooter{Tom Lane}
> \CFooter{O'Reilly Open Source Convention, July 2002}

Yes, this one was it.

> I'm not sure where it is on the website either; there used to be a link
> in the developer materials but it may be gone.  Anyway there's still a
> PDF of the slides in my home directory on cvs.postgresql.org.

Got it, thanks!  This is excellent material and it should definitively
be in the website.  The 7.4 optimizer talk (oscon 2003) is great too.
Too bad you weren't writing new ones for subsequent releases!

Since this was publically released in the past, I assume this is OK to
distribute?

-- 
Alvaro Herrera                               http://www.PlanetPostgreSQL.org/
"We're here to devour each other alive"            (Hobbes)

Alvaro Herrera <alvherre@commandprompt.com> writes:
> Since this was publically released in the past, I assume this is OK to
> distribute?

Sure, no problem.
        regards, tom lane

On Wed, 13 Jun 2007, Tom Lane wrote:

> Alvaro Herrera <alvherre@commandprompt.com> writes:
>> I remember there used to be somewhere a link to a talk Tom gave (on
>> OSCON 2001 maybe?) on transaction processing, SERIALIZABLE, SELECT FOR
>> UPDATE, etc.  I'm pretty sure it was linked to somewhere in the old
>> developers page, but I cannot find it in the new one or elsewhere.  I
>> searched the OSCON site but it isn't showing up either.
>
> I think you mean
>
> \Header{PostgreSQL Concurrency Issues}
> \LFooter{Tom Lane}
> \CFooter{O'Reilly Open Source Convention, July 2002}
>
> I'm not sure where it is on the website either; there used to be a link
> in the developer materials but it may be gone.  Anyway there's still a
> PDF of the slides in my home directory on cvs.postgresql.org.

Interesting, that google points to my page
http://www.sai.msu.su/~megera/postgres/gist/papers/concurrency/concurrency.pdf


>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83