What do you do when the database is maxed out, the busiest day of your year is six months away, and you still don't know what's actually wrong? Andrew Atkinson joins us to talk through that exact scen...

Explore this post and more from the PostgreSQL community

A 3-day PostgreSQL community conference in New York City, USA.

I see users excited by REPACK in PostgreSQL 19 (currently in beta), because it looks like a simple...

Nik and Michael are joined by Radim Marek to discuss MVCC, including his recent article on how Postgres chose to implement it compared to other systems.   Here are some links to things they mention...

### Impact In its default configuration, a Rails application that displays image variants may allow an unauthenticated attacker to read arbitrary files from the server, including the process envi...

You can have your cake and eat it, as long as you bake it carefully. ‘We can do this the quick way and pay later, or the thorough way and pay now.’ This seems to be a fundamental dichotomy in software...

6 comments

E.1. Release 19 # E.1.1. Overview E.1.2. Migration to Version 19 E.1.3. Changes E.1.4. Acknowledgments Release date: 2026-??-??, AS OF 2026-05-14 E.1.1. Overview …

📌 Overview Ruby on Rails has helped make it possible to scale out the database layer, meeting the demands of millions of Aura Frames customers enjoying their digital photo frames. In late 2025, the te...

📌 Overview On Christmas Day 2024, Postgres infrastructure powering the Aura Frames API had problems under peak load, being unavailable for three hours and disrupting the experience for new customers. ...

📌 Overview On Christmas Day 2024, Postgres infrastructure powering the Aura Frames API had problems under peak load, being unavailable for three hours and disrupting the experience for new customers. ...

Async I/O, UUIDv7, skip scan, virtual generated columns, RETURNING OLD/NEW, OAuth 2.0, statistics-preserving upgrades, temporal constraints…

https://www.postgresql.org/about/news/postgresql-19-beta-1-released-3313/

What pg_stat_statements records and what it quietly drops: the queryid jumble that splits one query into many rows, the frozen first-seen query text, and averages that hide your p99.

A sad look at the state of modern programming books.

Motivation / Background This pull request adds support for RETURNING clauses to INSERT/UPDATE/DELETE statements in Arel. This is useful to build queries that modify data and return it (or something...

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 ri...

Fully distributed PostgreSQL