Using the PostgreSQL System Catalogs

Talk Type: 

90 Minute Mini-tutorial

Technical Level: 
Intermediate
License: 
Creative Commons - Attribution Only

The PostgreSQL system catalogs store metadata about SQL objects such as tables, clumns, functions, schemas, and more. This talk will explore the organization and structure of the system catalogs and explain how you can use these catalogs to manage and tune your database. We'll cover applications such as (1) getting a list of all tables that have no indices, (2) determining which tables or databases are taking up the most space on disk, and (3) examining the statistics gathered by the query planner, as well as the internal structure of the catalogs and how they're used by the database system.

AttachmentSize
Using the PostgreSQL System Catalogs.odp145.03 KB