Sammlung von Newsfeeds

Karen Jex: PostgreSQL Europe Diversity Task Force (Deep Dive and Updates)

Neues vom PostgreSQL Planet - 28. Mai 2025 - 19:05

I'm sharing the slides and transcript from my talk about the PostgreSQL Europe Diversity Task Force at PostgreSQL Development Conference 2025.

It's an extended version of the 5 minute lightning talk that I gave at FOSDEM PGDay earlier this year, with some updates on what we've achieved.

If you want a shorter read, feel free to check out the annotated slides from the lightning talk instead!

Andrew Farries: pgroll 0.13.0: Start using pgroll on existing databases with the new baseline feature

Neues vom PostgreSQL Planet - 27. Mai 2025 - 11:00
The new baseline feature in pgroll 0.13.0 makes it easy to start using pgroll on databases with existing schema and keep your schema histories clean.

warda bibi: How to Upgrade Major PostgreSQL Versions: A Practical Production Guide

Neues vom PostgreSQL Planet - 27. Mai 2025 - 9:31

PostgreSQL versions follow a well-defined five-year support lifecycle. Each major release receives bug fixes, security patches, and minor updates for five years from its initial release date. After that point, the version reaches end-of-life (EOL) and no longer receives official updates.

Henrietta Dombrovskaya: Prairie Postgres Developers Summit

Neues vom PostgreSQL Planet - 27. Mai 2025 - 3:38

Even before the Community Summit in Montreal, I wanted to organize a Developers Summit at one of our meetups. My inspiration came from the Open spaces at DevOps Day Chicago. I saw how productive the smaller group discussions could be, and wanted to try to discuss different aspects of interactions.

We finally made it happen on May 22! In the meetup announcement, I asked those signing up to vote for topics we wanted to suggest and name additional topics. Then, when a meetup started, we re-voted the topics, and same as in Montreal, the outcome was different :).

Andreas 'ads' Scherbaum: Dirk Krautschick

Neues vom PostgreSQL Planet - 26. Mai 2025 - 16:00
PostgreSQL Person of the Week Interview with Dirk Krautschick: I am Dirk, living near Aachen in Germany and I am actually a Senior Solution Architect with Aiven and a former DBA, Trainer, Consultant and Sales Engineer in several companies but alway related to databases - first Oracle only, later Oracle together with PostgreSQL.

Jimmy Angelakos: Contributions for the week of 2025-05-19 (Weeks 20/21 overview)

Neues vom PostgreSQL Planet - 26. Mai 2025 - 15:17

Ian Barwick: PgPedia Week, 2025-05-25

Neues vom PostgreSQL Planet - 26. Mai 2025 - 13:30
PostgreSQL 18 changes this week

Sadly two features were reverted this week:

planner optimization "Partitions pruned by initial pruning are no longer locked" (commit 525392d5 , reverted in commit 1722d5eb ) function pg_get_process_memory_contexts() (commit 042a6629 , reverted in commit fb844b9f ) PostgreSQL 18 articles UUIDv7 Comes to PostgreSQL 18 (2025-05-09) - Gwen Shapira

more...

Jan Wieremjewicz: PostgreSQL 18 - Top Enterprise Features (fast read)

Neues vom PostgreSQL Planet - 26. Mai 2025 - 2:00

So the Beta1 is available for PostgreSQL 18 and while not all the features have to make it to GA, we can surely hope they do!

Taking a close look at what’s coming, here below is the selection of what excites me in particular:

Álvaro Hernández: How to Build Postgres with Zig: A Drop-In GCC/Clang Alternative

Neues vom PostgreSQL Planet - 23. Mai 2025 - 16:52
What’s Zig and Zig’s C/C++ compiler?

In case you are not familiar with it, Zig is a programming language. Among other characteristics, Zig prides itself on being a low-level / systems programming language with great interoperability with C and C++.

Andrew Atkinson: Big Problems From Big IN lists with Ruby on Rails and PostgreSQL

Neues vom PostgreSQL Planet - 23. Mai 2025 - 16:30
Introduction

If you’ve created web apps with relational databases and ORMs like Active Record (part of Ruby on Rails), you’ve probably experienced database performance problems after a certain size of data and query volume.

In this post, we’re going to look at a specific type of problematic query pattern that’s somewhat common.

Jeremy Schneider: Collation Torture Test versus Debian

Neues vom PostgreSQL Planet - 23. Mai 2025 - 7:37

Collation torture test results are finally finished and uploaded for Debian.

https://github.com/ardentperf/glibc-unicode-sorting

The test did not pick up any changes in en_US sort order for either Bullseye or Bookworm

Buster has glibc 2.28 so it shows lots of changes – as expected.

Henrietta Dombrovskaya: Community Summit at PGConf.dev

Neues vom PostgreSQL Planet - 23. Mai 2025 - 4:58

Last week, I presented at the PGConf.dev for the first time and participated in a community summit for the first time. The idea was pitched by Teresa Giacomini, and that’s how this event was described in the program:

cary huang: Postgres Extensions Day 2025 Kicks Off with a Successful Debut in Montréal

Neues vom PostgreSQL Planet - 22. Mai 2025 - 20:48
Introduction

PostgreSQL Extension Day 2025 made its successful debut on May 12, 2025, just one day before the start of pgconf.dev 2025. This focused one-day event brought together the community around a single theme: the PostgreSQL extension ecosystem. From innovative ideas and development insights to discussions on safer extension building and delivery, the day was all about “everything extensions.”

semab tariq: Best Practices for TimescaleDB Massive Delete Operations

Neues vom PostgreSQL Planet - 22. Mai 2025 - 15:30

Welcome to the second part of our TimescaleDB best practices series! In the first part, we explored how to perform massive backfill operations efficiently, sharing techniques to optimize performance and avoid common pitfalls. If you haven’t had a chance to read the first part yet, you can check it out using this link

In today’s blog, we will discuss another crucial aspect of time-series data management: massive delete operations.

Hubert 'depesz' Lubaczewski: pg_dump speed across versions

Neues vom PostgreSQL Planet - 22. Mai 2025 - 9:44
Got interested recently in speed of pg_dump. Specifically, if, over the years, it has became faster, and if yes, how much. Couple of years ago I was in position where we needed to run pg_dump, and found some inefficiencies, which got later patched. This was around the version 12. So, how does the situation look … Continue reading "pg_dump speed across versions"

cary huang: pgconf.dev 2025 Wraps Up with Great Success in Montreal

Neues vom PostgreSQL Planet - 22. Mai 2025 - 1:31
Introduction

pgconf.dev 2025 just wrapped up in Montreal, Canada, following its successful debut in Vancouver last year—and once again, it delivered a fantastic mix of deep technical content and strong community social activities.

Gülçin Yıldırım Jelínek: Xata Agent v0.3.1: Custom tools via MCP, Ollama integration, support for reasoning models & more

Neues vom PostgreSQL Planet - 21. Mai 2025 - 14:30
Version 0.3.1 of the open-source Xata Agent adds support for custom MCP servers and tools, introduces Ollama as a local LLM provider, and includes support for reasoning models O1 and O4-mini.

Dian Fay: pdot 1.0.0: Exploring Databases Visually, Part III

Neues vom PostgreSQL Planet - 21. Mai 2025 - 2:00

In what I can't say isn't a tradition at this point, we're in an odd-numbered year so there's news on the pdot front! Get it here!

DARIA NIKOLAENKO: Data archiving and retention in PostgreSQL. Best practices for large datasets

Neues vom PostgreSQL Planet - 20. Mai 2025 - 19:08

Just over a week ago, I attended PGConf.DE 2025 in Berlin with the rest of the Data Egret team and gave a talk titled “Data Archiving and Retention in PostgreSQL: Best Practices for Large Datasets.” This post is a written version of my talk for those who couldn’t attend.

Below, you’ll find each slide from the talk — along with what was said.

Seiten