Pick your PostgreSQL locale wisely: C.UTF-8 for speed, ICU for multilingual accuracy, or POSIX if you're ASCII-only and desperate.

Comparing PostgreSQL collation methods reveals surprising performance gaps: ICU beats libc by 5x for language-specific sorts, while the built-in C.UTF8…

When locale libraries change beneath your database, indexes silently break. Learn why this happens and how PostgreSQL now warns you.

PostgreSQL offers three locale providers—libc, ICU, and the new builtin provider—each with different trade-offs for character collation and localization.

Use UTF-8 for your PostgreSQL database. We explain why it's the right choice and when the performance argument for C encoding actually fails you.

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.