Mission Critical Databases

Webinar: pg_catalog Unveiled! That part of PostgreSQL you are probably underusing

This webinar was held on 8 April 2020.

PostgreSQL users want to know how the system is performing. This is valid for DBAs, system administrators, and developers. They want to know if the system needs some improvements, but also to generate the occasional report requested by managers. Standard monitoring tools will monitor the CPU, RAM and I/O consumption, but they won't be able to tell you if indexes are being used, if tables are bloated, what is the lag of replication, what are the status of sessions connected, and many other interesting and useful things from PostgreSQL.

This webinar reviewed the possibilities offered by the PostgreSQL catalog. Plenty of information is available there but it is unknown to many users, and therefore unused. We explored how to exploit the catalog, how to send the information to other monitoring tools, and how the tables in pg_catalog are fundamentally interconnected to other topics such as performance, replication, MVCC, security, the universe and everything.

Preview:

PG_CATALOG Unveiled! That part of PostgreSQL you are probably underusing by Boriss Mejias HUBSPOT

Boriss Mejías is a PostgreSQL consultant and trainer. He has been working with PostgreSQL since version 9.1. First as part of his job related to other projects, and now with full dedication since he joined 2ndQuadrant in 2017.

He has a background as a teaching assistant and researcher on self-managing distributed systems and distributed transactional algorithms. 

In open source and free software, Boriss has contributed to the Mozart-Oz programming language and the Alfresco community. He is currently coordinating the PostgreSQL User Group in Belgium.