From time to time I need to check whether a managed Postgres provider supports auto_explain, and if so, which auto_explain parameters they support. Since it can be time-consuming to set up and test each of these, I wanted to create a reference for myself, and thought it might also be of interest to

Does it find a good plan for a partitioned table as for a single one?

What is row pattern recognition feature? Row pattern recognition (RPR) is a feature defined in the SQL standard. It allows to search for a s...

This post will look at the basics of PostgreSQL Savepoints within a Transaction.

In this blog we are talking about indexes. Speeding up index creation in PostgreSQL is one of the main topic.

pg_easy_replicate is a CLI orchestrator tool that makes the process of setting up and managing logical replication between PostgreSQL databases a breeze.

Your database should be easy to use, not a source of frustration. Xata easily integrates into your developer workflow, providing the best data experience for GitHub, Vercel and Netlify based deployments.

Today's release of multi-version schema migrations addresses one of the most common pain points of application deployment - keeping your application code and database schema in sync. You can now present two versions of your schema, both old and new, to client applications.

I wanted to understand: Is Postgres as a cache a really good idea? Can it indeed replace Redis? That’s what I want to find out today.

Learn how to implement effective auditing and monitoring in PostgreSQL to enhance security, compliance, and performance. Discover tools like pgAudit and best practices for tracking database activities and access.

PostgreSQL interface for Node.js.

Elizabeth breaks down the basics of what you need to know for using parallel queries in Postgres.

Pongo - Mongo but on Postgres and with strong consistency benefits - event-driven-io/Pongo

At Sin City Ruby 2024 earlier this year, I presented a series of advanced PostgreSQL topics to Rails programmers. Afterwards, a number of people provided feedback on surprising or interesting things from the presentation.

Cut the number of required PostgreSQL server round-trips by up to 50% using the `AND CHAIN` parameter of the `COMMIT` and `ROLLBACK` statements.

Database servers are usually long-lived, and important parts of the infrastructure that we build on. We rarely set them up from scratch, because we have to take such good care of them over time. I think this causes a lot of people to think that setting up a database server is some mysteriously difficult ordeal. To be clear, that’s actually true, if you need high availability and a solid recovery point objective.

Should you use an Object-Relational Mapping (ORM) layer in PostgreSQL? Here’s what we see as the pros and (many) cons.

In-memory Postgres for unit/E2E tests.

Visualizing and understanding your PostgreSQL execution plans made easy.

Personal website of Andrea Zanin

So you have a bunch of data that comes from some human source (Free text form fields, reviews, blogs, classified ads, social media) and you want to do some analysis on it. but with people being the way they are, you're going to have some problems: A...

In this post I want to take a look at Generated Columns which was introduced in Postgres 12.

Learn how custom `ENUM` types in PostgreSQL can affect `SELECT` queries and `ORDER BY` clauses. Be mindful of indexing and typecasting.

Hyperdrive (Cloudflare’s globally distributed SQL connection pooler and cache) recently added support for Postgres protocol-level named prepared statements across pooled connections. We dive deep on what it took to add this feature.

I decided to compile Postgres with LLVM this week but ran into failing tests due to server crashes. Here’s how to avoid the issue.