PGCon2011 - Add 4 Video (2015.09.18)
PGCon 2011
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Robert Haas |
| Schedule | |
|---|---|
| Day | Tutorials - 1 - 2011-05-17 |
| Room | DMS 1120 |
| Start time | 09:00 |
| Duration | 03:00 |
| Info | |
| ID | 305 |
| Event type | Workshop |
| Track | DBA |
| Language used for presentation | English |
Using The PostgreSQL System Catalogs
Database Introspection with PostgreSQL
The PostgreSQL system catalogs store metadata about SQL objects such as tables, columns, 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 table and database sizes on disk, and (3) monitoring table, session, and background writer activity, as well as the internal structure of the catalogs and how they're used by the database system.