On Sun, May 13, 2007 at 08:44:48PM +0200, Gerhard Wiesinger wrote:
> Are there some presentations or documents of the internals of PostgreSQL
> available?
>
> Especially I'm looking for the concepts and detailed internals of general
> transaction handling, internals of commit log, transaction logs,
> pg_multixact, pg_subtrans, pg_tblspc and pg_twophase.
>
> Also some comments about concurrent access with multiple processes,
> locking and shared memory concepts (or other communication systems used)
> would be nice.
>
> I already found
> http://www.postgresql.org/files/developer/internalpics.pdf
> but some comments are missing to understand it well.
Best bet is to use the source... src/backend/access/transam/README
should get you started.
--
Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)