Sammlung von Newsfeeds
Robins Tharakan: Settling COUNT(*) vs COUNT(1) debate in Postgres 19
Dave Stokes: DBeaver's Visual Query Builder
Quick! You need to create a complex query, but you don't remember how to join the tables. And you need to get it done ASAP.
You are in luck if you have an enterprise edition of DBeaver handy. You can drag and drop the tables and then adjust the clauses as needed without having to dig into the table definitions.
1. Open the database
Magnus Hagander: FOSDEM PGDay 2026 - Call for papers and registration open
The call for papers is now open for FOSDEM PGDay 2026. The CfP will run until December 15, 2025 at 11:59 CET. We will aim to notify speakers by December 17th, 2025 and publish the schedule before Christmas.
Esther Minano: pgstream v0.9.0: Better schema replication, snapshots and cloud support
Gabriele Bartolini: KubeCon NA Atlanta 2025: a recap and CloudNativePG’s path to CNCF Incubation
This blog post recaps my eventful participation in KubeCon + CloudNativeCon North America 2025 in Atlanta, highlighting the key decision by maintainers to formally apply for CNCF Incubation for the CloudNativePG operator.
Philippe Noël: ParadeDB 0.20.0: Simpler and Faster
Hans-Juergen Schoenig: Super fast aggregations in PostgreSQL 19
PostgreSQL 18 has just been born and we are already talking about the blessings of PostgreSQL 19 and beyond? Well, yes, and there is a good reason for it.
Andreas Scherbaum: PostgreSQL Conference Japan 2025
Floor Drees: PostgreSQL Contributor Story: Vaibhav Dalvi
Floor Drees: PostgreSQL Contributor Story: Akshay Joshi
Ian Barwick: PgPedia Week, 2025-11-23
Andreas Scherbaum: PostgreSQL Berlin November 2025 Meetup
Cornelia Biacsics: Contributions for week 47, 2025
Seven PostgreSQL contributors completed this year of Google Summer Of Code:
Contributors:
- Ahmad Gouda
- Ashutosh Sh
- Bassam Adnan
- Gaurav Patidar
- Mankirat Singh
- Mohab Yasser
- Tejas Tyagi
Mentors:
Robins Tharakan: PostgreSQL Buildfarm Members: A status update
Robins Tharakan: Managing PostgreSQL Buildfarm Members: A status update
Bruce Momjian: Two Database Videos
In the past few months, two new database videos were released on YouTube. From Hollerith to Stonebraker, from IMS to Postgres, the first video does a great job of walking through the history of databases in a way that I have never seen before.
Bruce Momjian: Cleanup Time
With 3k slides and 64 presentations (and more two pending), the Presentations section of my website was getting cluttered. (Okay, I guess it has been cluttered for a while.) I have restructured the sections, adding two, removing one, and moving superseded presentations to Old. Hopefully this will help website visitors more easily find useful information.
Paul Ramsey: PostGIS Performance: Data Sampling
One of the temptations database users face, when presented with a huge table of interesting data, is to run queries that interrogate every record. Got a billion measurements? What’s the average of that?!
One way to find out is to just calculate the average.
SELECT avg(value) FROM mytable;For a billion records, that could take a while!

