Description of transaction model for indexes - Mailing list pgsql-general

From Gerhard Wiesinger
Subject Description of transaction model for indexes
Date
Msg-id alpine.LFD.2.00.0901041203440.21179@bbs.intern
Whole thread Raw
Responses Re: Description of transaction model for indexes
List pgsql-general
Hello!

The transaction model is discussed in several areas:
http://www.packtpub.com/article/transaction-model-of-postgresql
The POSTGRES Data Model (1987)
http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.48.8578
The Design of POSTGRES (1986)
http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.48.1422

However: Is there a paper available, how indexes are handled inside the
transaction (e.g. visibility (not handled), concurrency, etc.)?
E.g. What happens on SELECT/INSERT/UPDATE/DELETE?

Some aspects can be found in:
http://www.pgcon.org/2008/schedule/attachments/54_PGCon2008-HOT.ppt

Thnx.

Ciao,
Gerhard

--
http://www.wiesinger.com/


pgsql-general by date:

Previous
From: Christophe Chauvet
Date:
Subject: Re: auto insert data every one minute
Next
From: Christian Schröder
Date:
Subject: Re: Query planner and foreign key constraints