determine snapshot after obtaining locks for first statement

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: determine snapshot after obtaining locks for first statement
Date: 2009-12-16 22:18:41
Message-ID: 4B290861020000250002D644@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The Cahill thesis mentions an interesting optimization -- they defer
determination of the snapshot until after any locks required for the
first statement have been acquired. Where the first statement was,
for example, an UPDATE, this reduced re-reads or rollbacks in the
face of concurrent modifications.

Does PostgreSQL currently do this? If not, would it make sense?

-Kevin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2009-12-16 22:20:33 Re: Largeobject Access Controls and pg_migrator
Previous Message Scott Bailey 2009-12-16 22:15:29 Re: Range types