Sammlung von Newsfeeds

Gabriele Bartolini: CNPG Recipe 18 - Getting Started with pgvector on Kubernetes Using CloudNativePG

Neues vom PostgreSQL Planet - 5. Juni 2025 - 22:42

Learn how to set up a PostgreSQL cluster with the pgvector extension on Kubernetes using CloudNativePG—all in a fully declarative way. This article walks you through the process in just a few minutes, from cluster creation to extension installation.

Tomas Vondra: Benchmarking is hard, sometimes ...

Neues vom PostgreSQL Planet - 5. Juni 2025 - 12:00

I do a fair number of benchmarks, not only to validate patches, but also to find interesting (suspicious) stuff to improve. It’s an important part of my development workflow. And it’s fun ;-) But we’re dealing with complex systems (hardware, OS, DB, application), and that brings challenges. Every now and then I run into something that I don’t quite understand.

Michael Christofides: Approximate the p99 of a query with pg_stat_statements

Neues vom PostgreSQL Planet - 4. Juni 2025 - 17:58

Cover photo by Luca Upper

I recently saw a feature request for pg_stat_statements to be able to track percentile performance of queries, for example the p95 (95th percentile) or p99 (99th percentile).

Claire Giordano: Ultimate Guide to POSETTE: An Event for Postgres, 2025 edition

Neues vom PostgreSQL Planet - 4. Juni 2025 - 17:26

POSETTE: An Event for Postgres 2025 is back for its 4th year—free, virtual, and packed with deep expertise. No travel needed, just your laptop, internet, and curiosity.

This year’s 45 speakers are smart, capable Postgres practitioners—core contributors, performance experts, application developers, Azure engineers, extension maintainers—and their talks are as interesting as they are useful.

Boriss Mejias: Contributions for the week of 2025-05-19 (Week 21)

Neues vom PostgreSQL Planet - 4. Juni 2025 - 12:06

[PGDay Blumenau 2025] (https://pgdayblumenau.com.br/) took place May 24 in Blumenau, Brazil, organized by João Foltran and Gustavo Lemos, with Sara Kruger and Leonardo Corsini as volunteers.

Speakers:

Josef Machytka: Boldly Migrate to PostgreSQL – Introducing credativ-pg-migrator

Neues vom PostgreSQL Planet - 3. Juni 2025 - 8:00

Many companies these days are thinking about migrating their databases from legacy or proprietary system to PostgreSQL. The primary aim is to reduce costs, enhance capabilities, and ensure long-term sustainability. However, even just the idea of migrating to PostgreSQL can be overwhelming. Very often, knowledge about the legacy applications is limited or even lost. In some cases, vendor support is diminishing, and expert pools and community support are shrinking.

Ian Barwick: PgPedia Week, 2025-06-01

Neues vom PostgreSQL Planet - 3. Juni 2025 - 1:00

If you, like me, set up read access to the PostgreSQL Git repository many years ago, and have been wondering why it's been returning fatal: Could not read from remote repository errors for the past few days, it's because git:// protocol support has been deactivated and maybe withdrawn entirely (see pgsql-www thread git repo "https://" working but "git://" is not ).

Resolution is to convert it to https:// , e.g.:

git remote set-url origin https://git.postgresql.org/git/postgresql.git

Kaarel Moppel: Yes, Postgres can do session vars - but should you use them?

Neues vom PostgreSQL Planet - 2. Juni 2025 - 23:00
Animated by some comments / complaints about Postgres’ missing user variables story on a Reddit post about PostgreSQL pain points in the real world - I thought I’d elaborate a bit on sessions vars - which is indeed a little known Postgres functionality. Although this “alley” has existed for ages...

Laurenz Albe: The Fun of Open Source: Roman Numerals in PostgreSQL

Neues vom PostgreSQL Planet - 2. Juni 2025 - 20:39


© Laurenz Albe 2025

Recently, I wrote about the power of open source. Now, power is good and important, but open source software has other good sides as well. One of these aspects is fun. I will showcase that with the recently introduced support for converting Roman numerals to numbers.

Andreas 'ads' Scherbaum: Dilan Tek

Neues vom PostgreSQL Planet - 2. Juni 2025 - 16:00
PostgreSQL Person of the Week Interview with Dilan Tek: My name is Dilan. I was born in Ankara, the capital of Turkiye. I love my city very much! Although I lived in Istanbul for a while for work, I returned to Ankara.

Karen Jex: Postgres Partitioning Best Practices

Neues vom PostgreSQL Planet - 2. Juni 2025 - 10:49

Slides and transcript from my talk, "Postgres Partitioning Best Practices", at PyCon Italia in Bologna on 29 May 2025.

Thank you to everyone who came to listen, apologies to the people who were turned away because the room was full (who knew so many people would want to learn about Partitioning!), and thank you for all the questions, which have given me lots of ideas for improvements.

I'll share the recording as soon as it's available.

Sarah Conway: SCaLE 22x: Bringing the Open Source Community to Pasadena

Neues vom PostgreSQL Planet - 2. Juni 2025 - 2:00

The Southern California Linux Expo (SCaLE) 22x, recognized as being North America’s largest community-run open source and free software conference, took place at the Pasadena Convention Center from March 6-9, 2025. When I say community-run, I mean it—no corporate overlords dictating the agenda, just pure open source enthusiasm driving four days of technical discussions and collaboration.

Andreas Scherbaum: Postgres Extensions Day Montréal 2025

Neues vom PostgreSQL Planet - 2. Juni 2025 - 0:00
On Monday before PGConf.dev, the Postgres Extensions Day 2025 took place. Same venue, same floor. A day fully packed with talks, and interesting discussions. This event shows once again that extensions in PostgreSQL are thriving. It also shows that there is a lot of work to do to make extensions more usable and discoverable for users. Just a few problems which where discussed: A database can only load one extension version.

semab tariq: Understanding Split-Brain Scenarios in Highly Available PostgreSQL Clusters

Neues vom PostgreSQL Planet - 30. Mai 2025 - 12:49

High Availability (HA) refers to a system design approach that ensures a service remains accessible even in the event of hardware or software failures. In PostgreSQL, HA is typically implemented through replication, failover mechanisms, and clustering solutions to minimize downtime and ensure data consistency. Hence, HA is very important for your mission-critical applications. 

Alexander Korotkov: Bridged Indexes in OrioleDB: architecture, internals & everyday use?

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

Since version beta10 OrioleDB supports building indexes other than B-tree. Bridged indexes are meant to support these indexes on OrioleDB tables.

David Wheeler: Postgres Extensions: Use PG_MODULE_MAGIC_EXT

Neues vom PostgreSQL Planet - 30. Mai 2025 - 0:09

A quick note for PostgreSQL extension maintainers: PostgreSQL 18 introduces a new macro: PG_MODULE_MAGIC_EXT. Use it to name and version your modules. Where your module .c file likely has:

PG_MODULE_MAGIC;

Or:

#ifdef PG_MODULE_MAGIC PG_MODULE_MAGIC; #endif

Change it to something like:

Andrew Atkinson: Tip: Put your Rails app on a SQL Query diet

Neues vom PostgreSQL Planet - 29. Mai 2025 - 19:29
Introduction

Much of the time taken processing HTTP requests in web apps is processing SQL queries. To minimize that, we want to avoid unnecessary or duplicate queries, and generally perform as few queries as possible.

Think of the work that needs to happen for every query. The database engine parses it, creates a query execution plan, executes it, and then sends the response to the client.

When the response reaches the client, there’s even more work to do. The response is transformed into application objects in memory.

Brandur Leach: Don't mock the database: Data fixtures are parallel safe, and plenty fast

Neues vom PostgreSQL Planet - 29. Mai 2025 - 15:00

The API powering our Crunchy Bridge product is written in Go, a language that provides a good compromise between productivity and speed. We're able to keep good forward momentum on getting new features out the door, while maintaining an expected latency of low double digits of milliseconds for most API endpoints.

Ahmet Gedemenli: pgstream v0.6.0: Template transformers, observability, and performance improvements

Neues vom PostgreSQL Planet - 29. Mai 2025 - 14:45
Learn how pgstream v0.6 simplifies complex data transformations with custom templates, enhances observability and improves snapshot performance.

Tomas Vondra: Advanced Patch Feedback Session (APFS) at pgconf.dev 2025

Neues vom PostgreSQL Planet - 29. Mai 2025 - 14:00

The pgconf.dev conference, a revamp of the original PGCon, happened about two weeks ago. It’s the main event for Postgres developers, and one of the things we’re trying is an Advanced Patch Feedback Session (APFS).

We first tried that last year in Vancouver, and then again in Montreal. But I realized many people attending the conference either are not aware of the event at all, or are not sure what it’s about. So let me explain, and share some reflections from this year.

Seiten