Today we are welcoming Sugu, the co-creator of Vitess, to the Supabase team. He is joining Supabase to build Multigres: Vitess for Postgres.

At Neon, we’ve recently completed our HIPAA compliance audit and are using PGAudit under the hood for the detailed audit trails.

Universally Unique Identifiers (UUIDs) are 128-bit values designed to ensure uniqueness across...

Personal Site Andrew Atkinson. PostgreSQL. Ruby on Rails, Elasticsearch, Kubernetes, Vim. Author High Performance PostgreSQL for Rails Pragmatic Programmers

Personal Site Andrew Atkinson. PostgreSQL. Ruby on Rails, Elasticsearch, Kubernetes, Vim. Author High Performance PostgreSQL for Rails Pragmatic Programmers

PostgreSQL 18 adds native support for UUIDv7. A timestamp-based UUID variant that plays nicely with btree indexes. Here's what that means for you.

We are excited to announce the public preview of the brand-new PostgreSQL extension for Visual Studio Code (VS Code), designed to simplify PostgreSQL...

Manage PostgreSQL table partitions. Contribute to honeybadger-io/pg_partition_manager development by creating an account on GitHub.

Bloat refers to the unused space within database objects like tables and indexes, caused by accumulated dead tuples that have not been reclaimed by the...

Since early 2022, Motion was on CockroachDB. Cockroach has many qualities going for it: effortless horizontal scaling, especially when…

Postgres 18 introduces Asynchronous I/O (AIO) that can dramatically improve read performance, especially in the cloud. Learn how these changes and the new io_method setting work and see why our benchmark results show that io_uring is the recommended setting for maximizing I/O performance in Postgres 18 over the default setting 'worker'.

pg_filedump provides facilities for low-level examination of PostgreSQL tables and indexes - df7cb/pg_filedump

When you drop a column in Postgres, the data doesn't actually go away - here's why, and what that means for you

Horizontal scaling for PostgreSQL with automatic sharding. - pgdogdev/pgdog

Automatic reindexing of PostgreSQL indexes (bloat cleanup). - vitabaks/pg_auto_reindexer

Let's discuss micro-optimisations

A small follow up on my previous post on various Postgres scale-up avenues in my preferred order. The post received quite a bit of interest - meaning people at least still “wish” performant databases :) And - the ones who are willing to put in a bit of effort with...

YugabyteDB is rewriting the rules with an industry-first upgrade framework that delivers in-place, online, major version upgrades for PostgreSQL.

We've launched native logical replication from Postgres tables in any Postgres server to Iceberg tables managed by Crunchy Data Warehouse.

Adding extended statistics can add information about how columns are related. Louise has some real life example queries and tips for working with extended table stats that can dramatically improve query performance.

A very simple post about converting a postgres “interval” into an integer

Postgres Pro MCP Server supports you and your AI agents throughout the entire development process. - crystaldba/postgres-mcp

OrioleDB is a PostgreSQL extension that combines the advantages of both on-disk and in-memory engines.

After meeting with another database fellow recently - the evergreen topic of database scaling popped up again. That won’t go out of fashion anytime soon I guess, despite the AI advancements and the rise of Postgres-aware chatbots a la Xata Agent. Namely - when to grab for which designs, technical...