Neues vom PostgreSQL Planet
David Wheeler: RFC: PGXN Metadata Sketch
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
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.
Luca Ferrari: pgagroal-cli minor bug fixes
A few changes to a part of pgagroal.
pgagroal-cli minor bug fixesIn 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
I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 15 and PostgreSQL 16.
Setup:
Aditya Surishetti: Connecting to PostgreSQL with Go using PGX
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?
(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
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.
Paul Ramsey: Inside PostGIS: Calculating Distance
Calculating distance is a core feature of a spatial database, and the central function in many analytical queries.
David Wheeler: Building Trunk
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
Pierre Ducroquet: Look ma, I wrote a new JIT compiler for PostgreSQL
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?
Adrien Nayrat: Back from pgDay Paris 2024.
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
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
First of all here are the presentation slides:
Bertrand Drouvot: Postgres 17 highlight: Logical replication slots synchronization
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.