The stored procedure source code is compiled and optimized

The server processes the execution plan sequentially, dispatching each step to an appropriate internal manager process

The server saves the execution plan to disk for future use

The server resolves object references and creates a query tree

The process of resolving object references the first time the procedure is executed 

The process of recording the procedure's name and other information in the system catalog

The step where the procedure's source code is stored in syscomments for later use

The step where the query tree is constructed and passed to the query optimizer for compilation and optimization

To create a new stored procedure on the server

To compile a stored procedure

To execute a stored procedure

To view the source code of a stored procedure

A batch of SQL code that's stored on the server and can be executed repeatedly

A module that automatically creates indexes to optimize database performance

A table that stores frequently used SQL statements for quick access

A script written in another language that interacts with PostgreSQL databases

Key-value store

Relational database

Document store

Column-family store

Schema-based data model

Strict ACID compliance

Flexible schema

Vertical scaling only