Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 52 Minuten

Federico Campoli: PGDay Napoli 2025

13. Februar 2025 - 6:00

Finally I found time to get a grip on the issues I had with gohugo and get my blog operational again.

I’m taking the occasion to write about a project I care a lot as it’s strictly related with my hometown, the upcoming PGDay Napoli.

Henrietta Dombrovskaya: February Meetup: Postgres Full Text Search

13. Februar 2025 - 5:10

Every time I host a Postgres Meetup, I am thankful to everyone who comes. But today, I am especially thankful because so many people showed up despite the snowstorm! Staying after work to attend a meetup in these weather conditions demonstrates true dedication!

Many thanks to Steve Zelaznik for his wonderful presentations (recording will be available!), and thanks to all participants for listening, asking insightful questions, and a lively discussion afterward!

Peter Eisentraut: How about trailing commas in SQL?

11. Februar 2025 - 6:00

Anecdotally, this might be the most requested feature in SQL: Allow some trailing commas.

The classic example is

SELECT a, b, c, -- here FROM ...

Another one is

CREATE TABLE tab1 ( a int, b int, c int, -- here )

There might be a few other popular ones. (Please send feedback.)

Laurenz Albe: Dealing with the PostgreSQL error "found xmin ... from before relfrozenxid ..."

11. Februar 2025 - 6:00
© Laurenz Albe 2025

I have seen the error from the title reported often enough. If you are not familiar with the internals of PostgreSQL, the message will confuse you: what are xmin and relfrozenxid? Why is it a problem if one is before the other? So I think that it is worth the effort to write an article about the problem and what the error means. I'll also show you how to cope with the situation and fix the error.

Regina Obe: Learning PostgreSQL from AI and JSON exploration

11. Februar 2025 - 2:48

After reading Paul's teasing article on Accessing Large Language Models with AI and testing out his code, I decided I should probably stop fighting this AI smothering. I still have a distrust of AI services but downloading an AI model and using on my own local desktop or server is nice and I can break bread with that. One use I tried is using AI to generate fake data and it did a pretty decent job.

Paul Ramsey: The Early History of Spatial Databases and PostGIS

10. Februar 2025 - 17:00

For PostGIS Day this year I researched a little into one of my favourite topics, the history of relational databases. I feel like in general we do not pay a lot of attention to history in software development. To quote Yoda, “All his life has he looked away… to the future, to the horizon. Never his mind on where he was. Hmm? What he was doing.”

Brian Pace: Postgres Parallel Query Troubleshooting

10. Februar 2025 - 16:30

Postgres' ability to execute queries in parallel is a powerful feature that can significantly improve query performance, especially on large datasets. However, like all resources, parallel workers are finite. When there aren't enough available workers, Postgres may downgrade a parallel query to a serial (non-parallel) execution. This sounds reasonable unless the performance of the downgraded query is well beyond the required response times needed by the application.

Andrew Farries: pgroll 0.9.0 update

10. Februar 2025 - 15:30
pgroll v0.9 includes one breaking change, several improvements to table level constraint definitions and better CLI feedback

Floor Drees: Contributions for the week of 2025-02-03 (Week 5 overview)

10. Februar 2025 - 14:25

Organizing Committee FOSDEM PGDay and the PostgreSQL dev room at FOSDEM:

Andreas Scherbaum: PostgreSQL Berlin February 2025 Meetup

10. Februar 2025 - 0:00
On February 4th, 2025, we had the PostgreSQL February Meetup in Berlin. This time Zalando hosted it again, and we did something big: two tracks, two lightning talks and four regular talks. Oh, and about 130 attendees. That is already a mini conference! The Meetup took place in the Hedwig-Wachenheim-Straße in Berlin, right around the corner from the Uber Arena and East Side Gallery. Zalando has an office here, and the first floor is a large meeting and conference area.

Ian Barwick: PgPedia Week, 2025-02-09

9. Februar 2025 - 21:38
PostgreSQL 18 changes New GUC autovacuum_vacuum_max_threshold added WAL data added to pg_stat_io and backend statistics Support for  VIRTUAL generated columns added Disallow COPY FREEZE on foreign tables PostgreSQL 18 articles Waiting for PostgreSQL 18 – Support RN (roman-numeral format) in to_number() (2025-02-09) - Hubert 'depesz' Lubaczewski PostgreSQL 18: Introduce autovacuum_vacuum_max_threshold (2025-02-07) - Daniel Westermann / dbi services discusses the new autovacuum_vacuum_max_threshold GUC

Shayon Mukherjee: Scaling with PostgreSQL without boiling the ocean

9. Februar 2025 - 14:59
“Postgres was great when we started but now that our service is being used heavily we are running into a lot of ‘weird’ issues” This sentiment is frequently echoed by CTOs and senior engineers at high-growth startups when I speak with them. Scaling PostgreSQL successfully doesn’t always require a full team of DBAs and experts. The beauty of PostgreSQL is that solutions often lie within the database itself - by rethinking your data access patterns from first principles, you can solve many business problems at scale.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 18 – Support RN (roman-numeral format) in to_number().

9. Februar 2025 - 8:59
On 22nd of January 2025, Tom Lane committed patch: Support RN (roman-numeral format) in to_number().   We've long had roman-numeral output support in to_char(), but lacked the reverse conversion. Here it is.

Radim Marek: VIEW inlining in PostgreSQL

8. Februar 2025 - 1:00

Database VIEWs are powerful tools that often don't get the attention they deserve when building database-driven applications. They make our database work easier in several ways:

Ryan Booz: On Writing a Book About PostgreSQL

7. Februar 2025 - 20:51
“Publishing a book is an amazing experience. Writing a book is very, very hard.” Louis Davidson, Simple Talk Editor (@drsql) At the risk of burying the lede… “Introduction to PostgreSQL for the data professional” was officially published on Monday, February 3, 2025 and is available on Amazon, Barnes and Nobel, and through various Redgate channels. ... Read more

Paul Ramsey: Using Cloud Rasters with PostGIS

7. Februar 2025 - 16:30

With the postgis_raster extension, it is possible to access gigabytes of raster data from the cloud, without ever downloading the data.

How? The venerable postgis_raster extension (released 13 years ago) already has the critical core support built-in!

Pavlo Golub: FOSDEM 2025. A PostgreSQL Community Tradition

7. Februar 2025 - 7:00
Introduction

FOSDEM has long been a key event for the PostgreSQL community, and 2025 was no exception. Every year, PostgreSQL developers, contributors, and users worldwide gather in Brussels for a week packed with talks, meetings, and discussions. Our community has a strong tradition at FOSDEM, with a dedicated developer room, a booth, and numerous side events

Naisila Puka: Distribute PostgreSQL 17 with Citus 13

6. Februar 2025 - 19:45

The Citus 13.0 release is out and includes PostgreSQL 17.2 support! We know you’ve been waiting, and we’ve been hard at work adding features we believe will take your experience to the next level, focusing on bringing the Postgres 17 exciting improvements to you at distributed scale.

Sergey Solovev: PostgreSQL planner development and debugging

6. Februar 2025 - 16:52

This is translation of my report "Debugging PostgreSQL planner" from PGBootCamp 2024 conference.
You can find repository with source code and another staff here.

In this post we will look at how the PostgreSQL planner works, but on code level (functions and data structures) and how to hack on it's planner.

Stefanie Janine: Recap of FOSDEM and FOSDEM PGDay 2025

6. Februar 2025 - 0:00

FOSDEM PGDay 2025

For several years there is a PGDay in Brussels on the Friday before FOSDEM organized by PostgreSQL Europe.

The talks that I attended have been good. Only that it the speakers have not been very diverse.

Seiten