Scaling Postgres 374 is released! In this episode, we discuss how Jira migrated millions of databases, when sigterm does nothing, should you ditch vector search and mastering replication slots: #Postgres #PostgreSQL.

Scaling Postgres 373 is released! In this episode, we discuss the release of Planetscale Postgres and the advantages of bare metal, how often queries are optimal, avoiding UUIDv4 and the summer of upgrade report: #Postgres #PostgreSQL.

Scaling Postgres 372 is released! In this episode, we discuss some possible futures for Postgres architectures, choosing a multi-tenancy model, vectors in the new SQL standard and one way to perform a blue-green deployment rollback in AWS RDS: #PostgreSQL.

Scaling Postgres 371 is released! In this episode, we discuss how you use the database can impact its performance, performance of pg_search, fast uploads and some downsides of different upgrade methods: #Postgres #PostgreSQL.

Scaling Postgres 370 is released! In this episode, we discuss the start of Multigres which is a Vitess for Postgres, pgactive going open source, getting started with logical replication and a summer of upgrades: #Postgres #PostgreSQL.

Scaling Postgres 369 is released! In this episode, we discuss why and how you could move off of AWS RDS, Snowflake acquires Crunchy Data, reducing your SQL queries and a novel way to migrate to partition tables: #Postgres #PostgreSQL.

Scaling Postgres 368 is released! In this episode, we discuss the benefits of using time-based UUIDv7 vs UUIDv4 for primary keys, how OpenAI uses Postgres, handling locks and methods to migrate to partition tables with low downtime: #PostgreSQL #Postgres.

Scaling Postgres 367 is released! In this episode, we discuss a Postgres VS code extension, service definition files, undead tuples and the benefits of finding out how often a query is run: #Postgres #PostgreSQL.

Scaling Postgres 366 is released! In this episode, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features and a 20,000 times faster query by fixing an order by limit issue: #PostgreSQL.

Scaling Postgres 365 is released! In this episode, we discuss async I/O introduced in PG 18 Beta 1, new Postgres releases, PgDog performance and innovative ways to optimize queries: #Postgres #PostgreSQL.

Scaling Postgres 364 is released! In this episode, we discuss scaling for high volume, why workflows should be Postgres rows, a planner gotcha and ways to resolve planner issues: #Postgres #PostgreSQL.

Scaling Postgres 363 is released! In this episode, we discuss a top ten dos and don't for Postgres, understanding statistics and extended statistics, aligning columns to reduce padding and how to handle disaster recovery: #Postgres #PostgreSQL.

Scaling Postgres 362 is released! In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving low cardinality data columns: #Postgres #PostgreSQL.

Scaling Postgres 361 is released! In this episode, we discuss a roadmap to scaling Postgres, life altering Postgres patterns, making Postgres better with OrioleDB, performance cliffs and efficient use of foreign keys: #Postgres #PostgreSQL.

Scaling Postgres 360 is released! In this episode, we discuss how a new tool pgDog might allow one million client connections to Postgres, novel use cases for pgvector other than semantic search, don't expose port 5432 and Postgres on Kubernetes: #Postgres.

Scaling Postgres 359 is released! In this episode, we discuss indexes being added to Timescale's column store, processing 1 trillion metrics in Timescale, processing 1 trillion rows in Citus and partitions for deletion use cases: #Postgres #PostgreSQL.

Scaling Postgres 358 is released! In this episode, we discuss my experience attending Postgres Conference 2025 and cover some of the highlights of the conference: #Postgres #PostgreSQL.

Scaling Postgres 357 is released! In this episode, we discuss best practices, caching monitoring statistics, a new vector extension called VectorChord and the importance of monitoring wait events: #Postgres #PostgreSQL.

Scaling Postgres 356 is released! In this episode, we discuss immutability and Postgres, the upcoming Postgres Conference in Orlando, extended statistics and usage of default partitions: #Postgres #PostgreSQL.

Scaling Postgres 355 is released! In this episode, we discuss how Postgres & pg_mooncake achieves top ten Clickbench results, a comparison of Oracle and Postgres transactions, sharding to scale and connection counts: #Postgres #PostgreSQL.