GitHub Gist: instantly share code, notes, and snippets.

The traditional soft deletion pattern using <code>deleted_at</code> columns leaks into code, curbs the usefulness of foreign keys, and makes data removal difficult. Luckily, there’s an alternative.

gexec PostgreSQL poweruser practice: Learn how to use the gexec command and the `||` operator to get the best results out of your psql.

At Nile, we’re making it easier for companies to build world-class control planes for their infra SaaS products

This technical blog explains how CREATE INDEX CONCURRENTLY (CIC) works and how it manages to avoid locking the table from updates. A unique distinguishing factor of CIC is that it can build a new index on the table, without blocking it from updates/inserts/deletes.

Deep dive blog post about debugging and optimizing PostgreSQL autovacuum. Explores 3 common vacuum problem areas: when autovacuum doesn’t trigger vacuum often enough; when vacuum is too low; and when vacuum doesn’t clean up dead rows. Includes a cheat sheet…

Craig has pulled out some of his favorite functions from the Postgres toybox. He shows off date functions, aggregations, text functions, and math.

Turns out the question of which identifier to use as a Primary Key is complicated -- we're going to dive into some of the complexity and inherent trade-offs, and figure things out

I use PostgreSql a lot in my working time. So recently, I spent some time refreshing and deepening my knowledge of PostgreSQL to improve my skills and experience in using it (writing and optimizing queries, creating new objects, etc.). And I found many awesome…

How to fail loudly when you really should

Comparing one of the most popular Postgres features against alternatives

Doctolib is a continuous web service available 24/7 for practitioners and patients. As we have complete responsibility in the handling of…

If you've ever wondered - What is a tuple? What is a Postgres page? What's the difference between a record and a row? What is a relation? What's an array? What is TOAST? This post is for you! These are terms you hear all the time in the Postgres world. This…

Operations in online databases are always a tend to be a little tricky to carry out. Renaming a table safely in Postgres isn’t too hard, but there is some technique to it.

Enhance your PostgreSQL database performance with EDB's expert tuning tips. Optimize queries, autovacuum, and more for a faster, more efficient database.

As PostgreSQL table sizes grow into millions of rows, more customized settings are required to ensure optimal performance. Read more about Lob's approach.

A series of articles on how to solve common JSON problems with PostgreSQL®

I’m excited to announce that the translation of the “ PostgreSQL 14 Internals ” book is finally complete thanks to the amazing work of Liudmila Mantrova.
The final part of the book considers each of the index types in great detail. It explains and demonstrates…

Indexes in PostgreSQL come with a cost in terms of performance and resource consumption. Here are 10 different ways PostgreSQL indexes can hurt performance.

PostgreSQL monitoring with Prometheus is an easy thing to do thanks to the PostgreSQL...