PostgreSQL Internals Through Pictures BRUCE MOMJIAN, SOFTWARE RESEARCH ASSOCATES December, 2001 Abstract POSTGRESQL is an open-source, full-featured relational database. This presentation gives an overview of how POSTGRESQL processes queries. SQL Query SELECT firstname FROM friend WHERE age = 33; PostgreSQL Internals 1 Query in Psql test=> SELECT firstname test−> FROM friend test−> WHERE age = 33;