Chapter 59. Overview of PostgreSQL Internals

Chapter 59. Overview of PostgreSQL Internals
Prev	Up	Part VIII. Internals	Home	Next

Table of Contents

59.1. The Path of a Query

59.2. How Connections Are Established

59.3. The Parser Stage

59.3.1. Parser
59.3.2. Transformation Process

59.4. The PostgreSQL Rule System

59.5. Planner/Optimizer

59.5.1. Generating Possible Plans

59.6. Executor

Author

This chapter originated as part of [sim98] Stefan Simkovics' Master's Thesis prepared at Vienna University of Technology under the direction of O.Univ.Prof.Dr. Georg Gottlob and Univ.Ass. Mag. Katrin Seyr.

This chapter gives an overview of the internal structure of the backend of PostgreSQL. After having read the following sections you should have an idea of how a query is processed. This chapter is intended to help the reader understand the general sequence of operations that occur within the backend from the point at which a query is received, to the point at which the results are returned to the client.