The Postgres Guy
Videos
PostgreSQL tutorials, deep dives, and walkthroughs — learn Postgres visually.
How PostgreSQL Really Handles Connections
Every connection to PostgreSQL spawns a dedicated OS process. That isolation is a feature — until you have 500 of them sitting idle, eating RAM, and your app starts getting FATAL errors. Here's what's actually happening under the hood.
First Use Case for IQtoolkit Analyzer Index Advisor
A real-world walkthrough of using the IQtoolkit Analyzer's index advisor to identify missing indexes and optimize query performance in a production PostgreSQL database.
Auditing User Access in Postgres Databases for Security Compliance
How to audit user access in PostgreSQL databases to meet security compliance requirements. Covers role inspection, privilege analysis, and building access reports for auditors.
Understanding PostgreSQL TOAST: The 8KB Block Constraint and Oversized Data Storage
Deep dive into PostgreSQL's TOAST (The Oversized-Attribute Storage Technique) mechanism and how it works around the fundamental 8KB block size limitation. Learn when TOAST activates, how it stores large values, and the performance implications for your database design.
Exploring PostgreSQL Extensions and Their Functionality
A walkthrough of PostgreSQL's extension ecosystem — what extensions are, how they work, and which ones you should know about for production databases.
📖 Announcing: PostgreSQL Internals Mastery - Volume 1
PostgreSQL Internals Mastery Volume I is now available—a comprehensive foundation covering PostgreSQL architecture, memory management, storage, transactions, and durability. Learn how PostgreSQL really works at a systems level.
Why the iqtoolkit Suite Exists
After more than 10 years as a database professional, I built iqtoolkit to solve one problem: freeing DBAs from manual correlation hell so we can focus on what we actually want to do—architecture, automation, and engineering.