postgresql when it's not your job

Lies, Damn Lies, and LLM Output.

Do not expose port 5432 to the public Internet

VACUUM (INDEX_CLEANUP OFF) Considered Harmful

.pyc files and their discontents

Locale Cooking: Common Scenarios and Suggestions

Talk Fast: The Speed of Various Collations

The Doom That Came To PostgreSQL: When Collations Change

Farm to TABLE: Local(e) Providers

Speaking in Tongues: PostgreSQL and Character Encodings

“Gentlemen, this is a 🏈”: Glyphs, Encodings, Collations, and Locales

Checking Your Privileges, 2

Checking Your Privileges

“Look It Up: Real-Life Database Indexing” at PgConf.NYC

Don’t use ChatGPT to solve problems.

Running PostgreSQL on two ports

“Writing a Foreign Data Wrapper” at PGCon 2023

A little more on max_wal_size

The importance of max_wal_size

“Real-World Logical Replication” at Nordic PGDay 2023

“Database Antipatterns, and where to find them” at SCaLE 20x

Everything you know about setting `work_mem` is wrong.

Upcoming Live Presentations

Workers of the World, Unite!

ALTER TABLE … SET WITHOUT OIDS big gotcha

UUIDs vs serials for keys