When you are upgrading across major PostgreSQL versions, there are a few ways to go. Dump and restore is the simplest to reason about, but downtime scales directly with database size, so for...

Gwen Shapira shares how teams are scaling AI features using PostgreSQL for mission-critical apps. She explains how to leverage Postgres's multi-modal capabilities - including JSONB parsing and...

This post is about what PostgreSQL actually does when you write GRAPH_TABLE syntax. It turns out the database rewrites your graph query into ordinary joins against the underlying tables, then...

CYBERTEC在瑞士PgDay 2026展示了UNLOGGED实验，演示了Postgres中的UNLOGGED表如何提升性能。视频为快速记录，旨在捕捉活动氛围，团队将制作正式纪录片，并希望观众反馈对这种格式的看法。

I've been going to conferences and meetups of all kinds since 2004. And today — much like in the era when a Nokia brick was giving people their first, still-primitive taste of mobility — these...

This release was made 9 days ago, but I just realized that I neglected to make a blog post about it. So, for the record, here is the announcement that went out via email. I have released...

Ever have a query 'tossed over the fence' that you find incomprehensible but still have to support it? A few years ago, you would have needed to triage the query. Obfuscated queries can be tough...

PostgreSQL 20将支持UUID类型的min()和max()聚合函数，新增uuid_larger()和uuid_smaller()函数以比较UUID，返回最小和最大值。UUIDv7的时间戳特性使得这些函数能够按时间顺序返回数据，从而提升UUID的使用灵活性和效率。

Momentic, the company behind an AI-driven software testing platform, recently rearchitected its caching system to handle over 2 million queries per day across 20 billion total entries, while...

The backup node and DR server don’t need to share SSH keys. Here’s how pgBackRest’s native TLS transport provides certificate-authenticated restores and strict security isolation, making it the...