Neues vom PostgreSQL Planet

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

Regina Obe: PostGIS 3.7.0alpha1

5. Juli 2026 - 2:00

The PostGIS Team is pleased to release PostGIS 3.7.0alpha1! Best Served with PostgreSQL 19 Beta1 and GEOS 3.15 which will be released soon.

This version requires PostgreSQL 14 - 19beta1, GEOS 3.10 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.15+ is needed. To take advantage of all SFCGAL features SFCGAL 2.3.0+ is needed.

Henrietta Dombrovskaya: PG DATA 2026 recap, and looking forward to PG DATA 2027

4. Juli 2026 - 20:10

It has been a month since PG DATA 2026, the first full-scale event organized by Prairie Postgres. Looking at the feedback we received from the seekers, sponsors, and participants (and regrets of those who were unable to come :)), I couldn’t be happier with how it went.

Christophe Pettus: All Your GUCs in a Row: enable_parallel_append

4. Juli 2026 - 3:00
Parallel Append spreads workers across partitions or UNION branches simultaneously, not sequentially.

Shaun Thomas: Looking Forward to Postgres 19: Checksums For All

3. Juli 2026 - 15:42

Data checksums are one of those Postgres features that, when they are doing their job, are easily forgotten. They sit quietly in the header of every data page as a small integer fingerprint, forever waiting to thwart the threat of cosmic rays or errant hardware failures. Most clusters run from cradle to grave and never trip a single one.For years, that decision was etched in stone at the time of database initialization.

Floor Drees: Jumping the gun: looking ahead at PostgreSQL 19

3. Juli 2026 - 14:28

April 8 marked the start of feature freeze for PostgreSQL 19. For anyone unfamiliar with the PostgreSQL development cycle, that means that as of April 8 no new features are accepted for the upcoming major version. From April until the final release in the second part of the year, the community works on beta releases, bug fixes, and documentation. If a major feature isn't ready by the April deadline, it cannot be "snuck in." Conversely, stuff that is committed before the feature freeze isn't automatically making it into the new version as is.

Floor Drees: Meeting in Montreal: Developer U plan(ner) patches

3. Juli 2026 - 14:19
We wrote about the program we run internally for colleagues who show promise for PostgreSQL development on this blog before. Last week, a good portion of that group met in-person for the 3rd time. A summary of the topics discussed, patches submitted, and a look ahead to what's next for this group.

Antony Pegg: How to Build a RAG Server on pgEdge Cloud via the API

3. Juli 2026 - 13:15

This blog is going to show you how to set up your own RAG Server on pgEdge Cloud. The Cloud UI makes this so easy it is almost insulting - a few clicks and you are done - so I am going to show you the harder and more interesting path instead: the Cloud API. Everything below is a real call you can adapt. Replace anything in with your own values, and keep your API keys out of your shell history.Click on "Services" under your database, click on "Add RAG Server" and enter your config. see? sooo easy. Soooo boring.

Thom Brown: LOAD "PL/CBMBASIC",8,1: Commodore 64 BASIC for PostgreSQL

3. Juli 2026 - 10:50

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 listing from a magazine, getting ?SYNTAX ERROR IN 2340, and not knowing which of the three pages contained the typo. You remember that the disk drive was device 8, and that it was slower than continental drift.

I have some news. All of that now runs inside PostgreSQL.

Henrietta Dombrovskaya: Estonia PUG Meetup

3. Juli 2026 - 6:31

Yesterday, I had the pleasure of presenting at the Postgres User Group Estonia, and that was a delightful experience! Many thanks to Ervin Weber, who literally spent three years trying to make it happen. I was happy to give back to one of my favorite places in the world – the city of Tallinn.

Christophe Pettus: All Your GUCs in a Row: enable_nestloop

3. Juli 2026 - 3:00
Nested loop joins are PostgreSQL's most notorious performance disaster—but only when the planner misestimates row counts.

Seiten