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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
