A guide to fuzzy searching in PostgreSQL

Common DB schema change mistakes and how to avoid them in PostgreSQL development.

Useful PostgreSQL Queries and Commands. GitHub Gist: instantly share code, notes, and snippets.

So far we've discussed query execution stages , statistics , and the two basic data access methods: Sequential scan and Index scan .
The next item on the list is join methods. This article will remind you what logical join types are out there, and then discuss…

Paul looks under the covers at Postgres query plans, indexes, filters, and statistics.

Gaining additional insights and understanding your PostgreSQL workload is critical, and pg_stat_monitor can help you do both. 

Recently I was asked to look into a case where an identical SQL executed on the same database in two...

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