Characters, encodings, and collations: the fundamentals of how PostgreSQL handles human language.

Check out the slides from my latest talk, adapted from the previous blog post on PostgreSQL performance tuning.

PostgreSQL grants EXECUTE on new functions to PUBLIC by default, which might let unwanted users run your "secret" functions. Here's how to lock them down.

Slides from "Look It Up: Real-Life Database Indexing" are now live. Learn practical indexing strategies that actually work in production PostgreSQL systems.

ChatGPT gave wrong answers to 23 of 40 PostgreSQL questions—including one that would corrupt your database. LLMs aren't a substitute for real expertise.

PostgreSQL only listens on one port, but you can use pgbouncer or stunnel to accept TLS connections on a second port and route them to your server.

Learn the architecture and skills you need to build a PostgreSQL foreign data wrapper that reads from external data sources.

Higher max_wal_size means faster checkpoints but slower crash recovery. Here's how to balance the tradeoff based on what matters most to your system.

Frequent checkpoints kill PostgreSQL performance—here's how to tune max_wal_size to stop them from happening too often.

Slides from "Real-World Logical Replication" are now live. Dive into practical patterns for PostgreSQL's most powerful replication feature.