Sammlung von Newsfeeds

I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 15 and PostgreSQL 16.

Setup:

PostgreSQL has emerged as a reliable, feature-rich database used extensively across various industries. On the other hand, Go (Golang), known for its simplicity, efficiency, and strong standard libraries, has become increasingly preferred for modern backend development. In this article we will discuss PGX – a powerful, lightweight, and easy-to-use driver for accessing PostgreSQL databases in […]

(Disclosure: I’m on the PostgreSQL Core Team, but what’s written in this post are my personal views and not official project statements…unless I link to something that’s an official project statement ;)

A few weeks ago I brainstormed about decentralized Postgres extension publishing, inspired in part by an examination of Go decentralized publishing.

On 17th of March 2024, Dean Rasheed committed patch: Add RETURNING support to MERGE.   This allows a RETURNING clause to be appended to a MERGE query, to return values based on each row inserted, updated, or deleted. As with plain INSERT, UPDATE, and DELETE commands, the returned values are based on the new contents … Continue reading "Waiting for PostgreSQL 17 – Add RETURNING support to MERGE."

Calculating distance is a core feature of a spatial database, and the central function in many analytical queries.

This week, my fellow Tembonaut Ian Stanton will present the extension ecosystem mini-summit talk, “Building Trunk: A Postgres Extension Registry and CLI”.

PostgreSQL Person of the Week Interview with Florent Jardin: I am from Lille, the capital of Flanders in the north of France, and I have been living here since birth.

Sometimes, I don’t know why I do things. It’s one of these times. A few months ago, Python 3.13 got its JIT engine, built with a new JIT compiler construction methodology (copy-patch, cf. research paper). After reading the paper, I was sold and I just had to try it with PostgreSQL. And what a fun ride it’s been so far. This blog post will not cover everything, and I prefer other communication methods, but I would like to introduce pg-copyjit, the latest and shiniest way to destroy and segfault speed up your PostgreSQL server.

Recently someone asked on Slack about what is transaction wraparound. Full answer is a bit too much for slack reply, but I can try to explain it in here. So, every row in PostgreSQL containst two hidden columns: xmin, and xmax. You can see them: =$ CREATE TABLE wrapit (a int4); CREATE TABLE   =$ … Continue reading "What the hell is transaction wraparound?"

I’m back from pgDay Paris. I really enjoyed this edition. I’d already come to the 2019 one, and I must say I wasn’t deceived. As a reminder, pgDay Paris is an international conference. Presentations are in English, attracting more English speakers and audiences.

The past few releases of pgvector have emphasized features that help to vertically scale, particularly around index build parallelism. Scaling vertically is convenient for many reasons, especially because it’s simpler to continue managing data that’s located within a single instance.

First of all here are the presentation slides:

Introduction

PostgreSQL 17 will normally (as there is always a risk of seeing something reverted in the beta phase) include this commit: Add a new slot sync worker to synchronize logical slots.

At PeerDB, we are building a fast and a cost-effective way to replicate data from Postgres to Data Warehouses and Queues. Today we are releasing our Azure Event Hubs connector. With this, you get a fast, simple, and reliable way for Change Data Captu...

Great turnout and discussion for the first in a series of community talks and discussions on the postgres extension ecosystem leading up to the Extension Ecosystem Summit at pgconf.dev on May 28. Thank you!

The talk, “State of the Extension Ecosystem”, was followed by 15 minutes or so of super interesting discussion. Here are the relevant links:

Postgres is an amazing database system, but it does come with a five-year life cycle. This means you need to perform a major upgrade of it at least every five years. Luckily, Postgres ships with the pg_upgrade program, which enables a quick and easy migration from one major version of Postgres to another.

Learn about database clusters, databases, and tables to optimize performance and unleash the full potential of PostgreSQL for your projects.

The post PostgreSQL Internals Part 1: Understanding Database Cluster, Database and Tables appeared first on Stormatics.

What is High Availability to Postgres? I’ve staked my career on the answer to that question since I first presented an HA stack to Postgres Open in 2012, and I still don’t feel like there’s an acceptable answer. No matter how the HA techniques have advanced since then, there’s always been a nagging suspicion in my mind that something is missing. But I’m here to say that a bit of research has uncovered an approach that many different Postgres cloud vendors appear to be converging upon.

We are back with another event!

PgTraining Online Event 2024 (italian)

PgTraining, the amazing italian professionals that spread the word about PostgreSQL and that I joined in the last years, is organizing another online event (webinar) on next 19th April 2024.
Following the success of the previous edition(s), we decided to provide another afternoon full of PostgreSQL talks, in the hope to improve the adoption of this great database.