Sammlung von Newsfeeds

Cornelia Biacsics: Contributions for week 22, 2026

Neues vom PostgreSQL Planet - 9. Juni 2026 - 10:45

The Prague PosgreSQL User Group met on June 1, 2026, organized by Gülçin Yıldırım Jelínek and Mayur B.

Speaker:

  • Laurenz Albe
  • Josef Šimánek
  • Ants Aasma

PGDay France 2026 took place from June 3-4

Organizers:

Christoph Berg: PGConf.dev 2026 in Vancouver

Neues vom PostgreSQL Planet - 9. Juni 2026 - 6:00

The old Postgres Conferences always sounded interesting, but the conference being in Ottawa in Canada and me being in Europe, I've always dismissed them as "too far away" and never bothered going.

Then the organizing team changed and the conference moved to Vancouver for 2024. That's even further away. 2025 in Montreal was a bit closer again, but…

Christophe Pettus: All Your GUCs in a Row: DateStyle

Neues vom PostgreSQL Planet - 9. Juni 2026 - 3:00
PostgreSQL's DateStyle parameter does two unrelated things at once, which explains why it confuses everyone.

Stefanie Janine: My Three Top PostgeSQL 19 Features

Neues vom PostgreSQL Planet - 9. Juni 2026 - 0:00

PostgeSQL 19 beta 1 has been released on 2026-06-04.

The release is planned for September 2026, though it’s time to go through the new features and changes.

My Top Three Features

All three features below are cool and great developments from the authors of the patches that implemented them. But there are a lot of new cool features and extesnions to exisiting features done by a lot of people.

Vibhor Kumar: pg_background 2.0: Run SQL in the Background, Now Cleaner, Safer, and Ready for PostgreSQL 19

Neues vom PostgreSQL Planet - 8. Juni 2026 - 22:43

Every PostgreSQL developer eventually reaches the same architectural boundary, although the boundary usually appears as an ordinary product request rather than a database design problem. An application transaction needs to complete one business operation, but the surrounding platform also needs to write an audit record, launch a slow report, refresh a cache, fire a notification, or start some enrichment logic that should not delay the user.

Christophe Pettus: How the Other Half Counts

Neues vom PostgreSQL Planet - 8. Juni 2026 - 17:00
PostgreSQL's query planner gathers statistics one way; Oracle, Db2, MySQL, SQLite, DuckDB, and Snowflake each chose differently.

Christophe Pettus: All Your GUCs in a Row: data_sync_retry

Neues vom PostgreSQL Planet - 8. Juni 2026 - 3:00
data_sync_retry is a boolean, it defaults to off, and its context is postmaster so changing it needs a restart. You will almost certainly never change it. It exists as the visible scar tissue from the single most unsettling thing the PostgreSQL community ever learned about its own durability assu…

Stefanie Janine Stölting: pgsql_tweaks Version 1.0.3 Released

Neues vom PostgreSQL Planet - 8. Juni 2026 - 0:00
  1. pgsql_tweaks is a bundle of functions and views for PostgreSQL

  2. Christophe Pettus: All Your GUCs in a Row: data_directory_mode

    Neues vom PostgreSQL Planet - 7. Juni 2026 - 3:00
    PostgreSQL 11 lets you create a data directory with group read access (0750) instead of owner-only (0700), enabling unprivileged backup processes to copy files…

Christophe Pettus: All Your GUCs in a Row: data_directory

Neues vom PostgreSQL Planet - 6. Juni 2026 - 2:13
PostgreSQL solves a bootstrapping puzzle with `data_directory`: how to find the config file before knowing where the data lives.

Andrew Atkinson: Beta Testing PostgreSQL With Docker

Neues vom PostgreSQL Planet - 5. Juni 2026 - 22:15

The Postgres community values feedback from testing of Beta releases, and with Docker it’s been easier to get pre-release versions up and running.

With the recent announcement of PostgreSQL 19 Beta 1, let’s get that running and test some of the new capabilities.

Mark Wong: Acknowledged Individuals in the PostgreSQL Release Notes: 2026 Edition

Neues vom PostgreSQL Planet - 5. Juni 2026 - 18:36

I shared a chart, in 2022, showing where PostgreSQL contributor gifts are mailed to.  Here's an updated chart (click to zoom in.)

Shaun Thomas: Looking Forward to Postgres 19: Query Hints

Neues vom PostgreSQL Planet - 5. Juni 2026 - 14:02

Well, the world has officially ended. Peter Venkman from Ghostbusters was right all along, and we'll soon be experiencing "human sacrifice, dogs and cats living together, mass hysteria!" Pack it in everybody; we had a great run. The feature freeze of Postgres 19 includes the one feature many claimed would never see the light of day: query hints. I guess "never say never" is pretty good advice.OK, so they're not technically called hints. The Postgres community would never be so pedestrian.

Christophe Pettus: All Your GUCs in a Row: data_checksums

Neues vom PostgreSQL Planet - 5. Juni 2026 - 3:00
A read-only preset, like block_size — SHOW data_checksums tells you whether the cluster has page checksums, and that’s the only interaction the GUC offers. But unlike block_size, this one has a thirteen-year history that’s still being written, and the history is the post. When checksums are on, e…

Lætitia AVROT: A Reviewer Was Born

Neues vom PostgreSQL Planet - 5. Juni 2026 - 2:00
A friend of mine, Lucas Draescher, submitted his first patch to PostgreSQL back in March. It fixes a file descriptor leak when using io_method=io_uring. The patch is clean, well-motivated, and on its third revision. It has been sitting in the commitfest for two months with zero reviewers. This is not unusual. This is the norm. The PostgreSQL project runs on volunteer time. Committers are brilliant, but there are not many of them and the patch queue is long.

Floor Drees: How to test PostgreSQL 19 beta in your Kubernetes cluster

Neues vom PostgreSQL Planet - 5. Juni 2026 - 2:00
Participate in the PostgreSQL 19 beta program using Kubernetes and our CloudNativePG operator

warda bibi: File Descriptors: The OS Limit That Takes Down PostgreSQL

Neues vom PostgreSQL Planet - 4. Juni 2026 - 13:12

Most PostgreSQL outages that trace back to file descriptor exhaustion get misread as a database problem. The failure is one layer down: the kernel runs out of file descriptors and PostgreSQL takes the hit. This post covers how that happens under high connection counts, how to read the log sequence when it does, and how to fix it.

Stefan Fercot: Does pgBackRest work with pg_tde?

Neues vom PostgreSQL Planet - 4. Juni 2026 - 9:10

Percona Transparent Data Encryption for PostgreSQL (pg_tde) is an open-source PostgreSQL extension that provides Transparent Data Encryption (TDE) to protect data at rest. pg_tde ensures that data stored on disk is encrypted and cannot be read without the proper encryption keys, even if someone gains access to the physical storage media.

Christophe Pettus: All Your GUCs in a Row: cursor_tuple_fraction

Neues vom PostgreSQL Planet - 4. Juni 2026 - 3:00
The planner assumes cursors fetch only 10% of results by default. If you're actually reading them all, that fast-start bias could be killing your performance.

David Wheeler: pg_clickhouse 0.3.1: Now With More C

Neues vom PostgreSQL Planet - 3. Juni 2026 - 22:13

Hello listeners!

Seiten