Neues vom PostgreSQL Planet

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

Jeremy Schneider: Major Developments in Postgres Extension Discovery and Distribution

22. März 2024 - 6:28

PostgreSQL “extensions” are a big part of what makes this database special.

David Wheeler: RFC: PGXN Metadata Sketch

21. März 2024 - 19:50

This post proposes a new metadata standard for extension packaging, distribution, and delivery, building on the PGXN Meta Spec to address its shortcomings and emerging use cases 12 years on. The goals include:

muhammad ali: Transitioning from Heroku PostgreSQL to AWS EC2: Step-by-Step Guide

21. März 2024 - 19:10

The blog describes all the steps required to safely migrate your Heroku PostgreSQL database to self managed PostgreSQL on AWS EC2 instance using logshipping method.

The post Transitioning from Heroku PostgreSQL to AWS EC2: Step-by-Step Guide appeared first on Stormatics.

Peter Smith: A day in the life of a Postgres engineer at Fujitsu - Peter Smith

21. März 2024 - 1:03

We at Fujitsu have been actively contributing to the PostgreSQL opensource community since 2003, participating in the development of new features, bug fixes, and code review. Today I would like to talk about what a typical day is like as a Postgres engineer.


Luca Ferrari: pgagroal-cli minor bug fixes

21. März 2024 - 1:00

A few changes to a part of pgagroal.

pgagroal-cli minor bug fixes

In the past days I pushed a few troophy patches to pgagroal-cli, the command line tool to administer a pgagroal connection pooler, in order to fix minor issues that produced unattended results.

The bug were all harmless, since they only affected what the pgagroal-cli was producing as output to the user, but could have been confusing for some use cases, hence the need to fix them.

Pavel Stehule: compiled win x64 dll of orafce-4.9.3 and plpgsql_check-2.7.4 for PostgreSQL 15 and 16

20. März 2024 - 21:21

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


Aditya Surishetti: Connecting to PostgreSQL with Go using PGX

20. März 2024 - 15:46

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 […]

Jonathan Katz: Will PostgreSQL ever change its license?

20. März 2024 - 1:00

(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 ;)

David Wheeler: Extension Registry Namespacing RFC

19. März 2024 - 22:55

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

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Add RETURNING support to MERGE.

19. März 2024 - 19:41
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."

Paul Ramsey: Inside PostGIS: Calculating Distance

19. März 2024 - 14:00

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

David Wheeler: Building Trunk

18. März 2024 - 19:06

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

Andreas 'ads' Scherbaum: Florent Jardin

18. März 2024 - 15:00
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.

Pierre Ducroquet: Look ma, I wrote a new JIT compiler for PostgreSQL

18. März 2024 - 12:30

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.

Hubert 'depesz' Lubaczewski: What the hell is transaction wraparound?

18. März 2024 - 11:59
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?"

Adrien Nayrat: Back from pgDay Paris 2024.

18. März 2024 - 10:39

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.

Jonathan Katz: Distributed queries for pgvector

18. März 2024 - 1:00

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.

Henrietta Dombrovskaya: The Security Talk Maiden Voyage

16. März 2024 - 19:14

First of all here are the presentation slides:

Bertrand Drouvot: Postgres 17 highlight: Logical replication slots synchronization

16. März 2024 - 6:26

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.

Sai Srirampur: Enterprise-grade Replication from Postgres to Azure Event Hubs

15. März 2024 - 21:54
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...