Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 1 Stunde 38 Minuten

Jeremy Schneider: Postgres Booth at PASS Data Community Summit

1. Dezember 2025 - 0:40

PASS Data Community Summit 2025 wrapped up last week. This conference originated 25 years ago with the independent, user-led, not-for-profit “Professional Association for SQL Server (PASS)” and the annual summit in Seattle continues to attract thousands of database professionals each year. After the pandemic it was reorganized and broadened as a “Data Community” event, including a Postgres track.

Shinya Kato: Analyzing psqlrc Settings on GitHub: How PostgreSQL Engineers Configure PostgreSQL

30. November 2025 - 14:48
Introduction

Recently, I read an article titled "Alias Settings of Engineers Around the World" (in Japanese). As a PostgreSQL engineer, this got me thinking: "If they are customizing their bash aliases, how are they configuring their psql environments?"

Driven by curiosity, I decided to investigate GitHub repositories to see how developers commonly configure their psqlrc files.

Hubert 'depesz' Lubaczewski: Using JSON: json vs. jsonb, pglz vs. lz4, key optimization, parsing speed?

29. November 2025 - 20:16
Recently(ish) I had a conversation on one of PostgreSQL support chats (IRC, Slack, or Discord) about efficient storage of JSON data, which compression to use, which datatype. Unrelated to this, some people (at least two over the last year or so) said that they aren't sure if PostgreSQL doesn't optimize storage between columns, for example, … Continue reading "Using JSON: json vs. jsonb, pglz vs. lz4, key optimization, parsing speed?"

Robins Tharakan: Teaching Query Planner to See Inside C Functions

28. November 2025 - 20:30
The Postgres planner just got a new superpower: X-ray vision for your black-box functions. For years, Postgres has been able to "inline" simple SQL functions. If you wrote CREATE FUNCTION ... LANGUAGE SQL AS 'SELECT ...', the planner would often rip out the function call and paste the raw SQL directly into the main query. This was magic. It meant that WHERE clauses could be pushed down, indexes

Jan Wieremjewicz: TDE is now available for PostgreSQL 18

28. November 2025 - 12:00

Back in October, before PGConf.EU, I explained the issues impacting the prolonged wait for TDE in PostgreSQL 18. Explanations were needed as users were buzzing with anticipation, and they deserved to understand what caused the delays and what the roadmap looked like.

Robins Tharakan: Settling COUNT(*) vs COUNT(1) debate in Postgres 19

27. November 2025 - 14:29
A recent commit to the PostgreSQL master branch brings a nice quality-of-life optimization for a very common SQL pattern - improving performance by up to 64% for SELECT COUNT(h) where h is a NOT NULL column. If you've ever wondered whether you should use COUNT(*) or COUNT(1), or if you've been dutifully using COUNT(id) on a non-null column, this change is for you. Note: This feature is currently

Dave Stokes: DBeaver's Visual Query Builder

26. November 2025 - 21:15

 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

26. November 2025 - 12:52

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

26. November 2025 - 10:00
Bringing connection retries, anonymizer features, memory improvements and solid community input.

Gabriele Bartolini: KubeCon NA Atlanta 2025: a recap and CloudNativePG’s path to CNCF Incubation

26. November 2025 - 7:26

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

26. November 2025 - 1:00
Introducing search aggregation, V2 API as default, and performance improvements that eliminate the complexity between search and analytics in a single Postgres-native system.

Hans-Juergen Schoenig: Super fast aggregations in PostgreSQL 19

25. November 2025 - 6:40

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

24. November 2025 - 23:00
Back in July I submitted talks to the annual PostgreSQL Conference Japan 2025 (PostgreSQL カンファレンス 2025). This year is the 20th year of the conference, I was told. That is even longer running than our “own” PostgreSQL Conference Europe. To my surprise, one of my submitted talks was accepted. Which made me plan a trip to Japan and South Korea, to combine the conference

Floor Drees: PostgreSQL Contributor Story: Vaibhav Dalvi

24. November 2025 - 16:25
Earlier this year we started a program (“Developer U”) to help colleagues who show promise for PostgreSQL Development to become contributors. Meet Vaibhav Dalvi, Staff SDE, who, prior to joining EDB had no experience with databases! And now look at him!

Floor Drees: PostgreSQL Contributor Story: Akshay Joshi

24. November 2025 - 15:08
Earlier this year we started a program ("Developer U") to help colleagues who show promise for PostgreSQL Development to become contributors. Meet one of the participants: Akshay Joshi, a Principal Engineer and Engineering Manager at EDB.

Ian Barwick: PgPedia Week, 2025-11-23

24. November 2025 - 14:30
PostgreSQL 19 changes this week COPY ...

Andreas Scherbaum: PostgreSQL Berlin November 2025 Meetup

23. November 2025 - 23:00
On November 13th, 2025, we had the PostgreSQL November Meetup in Berlin. Redgate Software hosted us again, this time in a larger meeting room at The Social Hub Berlin. We had two speakers, and very tasty food. The event space is in Alexanderstraße 40, in Berlin Mitte. just five minutes away from Alexanderplatz. It is a event and gym venue, with several meeting rooms in various sizes, office area and a gym.

Cornelia Biacsics: Contributions for week 47, 2025

23. November 2025 - 21:22

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

22. November 2025 - 23:29
The PostgreSQL Buildfarm is a global network of machines that continuously test PostgreSQL across a wide range of operating systems, architectures, compilers, and branches. Over the past few years, I have created and maintained several buildfarm members, each with its own quirks and strengths. In this post, I’ll share a status-update working on the following animals: alligator, dodo,

Seiten