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

迁移生产环境中的PostgreSQL数据库到Kubernetes需要考虑数据转移、停机时间和操作复杂性等因素。文章介绍了从Crunchy Data PostgreSQL Operator迁移到Percona Operator的几种方法，强调每种方法适用于不同的操作场景。选择合适的迁移策略需平衡停机时间、复杂性和业务连续性，建议在测试环境中验证以确保安全高效的过渡。

PostgreSQL 20新增了后端级锁统计功能，用户可以通过pg_stat_get_backend_lock()实时监控每个后端的锁等待计数和等待时间。这将有助于诊断性能问题。

We had our first meetup on Thursday, July 2nd, organized by the community people for the community people. Bilge Korkmaz Erdim, Gülçin Yıldırım Jelínek, and I had been working on the meetup idea...

If you are of a certain age, the words 38911 BASIC BYTES FREE will do something to you that no amount of therapy can undo. You remember the blue screen. You remember typing in three pages of a...

For PostgreSQL administrators, DBAs, SREs, and platform teams, understanding how backup data moves through a system is just as important as knowing when a backup completed successfully. Questions...