Sammlung von Newsfeeds
Stefanie Janine: sparql_fdw Foreign Data Wrapper Tested Against PostgreSQL 17
The sparql_fdw is a foreign data wrapper to connect to query web databases with the SPARQL protocol from inside PostgreSQL written in Python.
Test Against PostgreSQL 17As multicorn2 is already working with PostgreSQL 17, I tested the sparql_fdw, too.
Greg Sabino Mullane: Enhanced Postgres Release Notes
There is something new you may not have seen in the release notes for Postgres 17. No, not a new feature - I mean inside the actual release notes themselves! The Postgres project uses the git program to track commits to the project, and now each item in the release notes has a link to the actual commit (or multiple commits) that enabled it.
David Wheeler: PGXN v2 Update
Speaking of PGXN news, I neglected to link to this post I wrote for the Tembo Blog last month, a fairly detailed accounting of what’s been happening on the PGXN v2 project:
David Wheeler: PGXN Certifications RFC
A couple weeks ago, I drafted PGXN RFC–5 — Release Certification, which proposes to replace the simple inclusion of a SHA-1 hash digests in PGXN release META.json files with a JWS-signed release payload. From the introduction:
David Wheeler: ⛰️ Postgres Ecosystem Summit EU
Given the success of the Extension Ecosystem Summit at PGConf.dev back in May, my colleague Floor Drees has organized a sequel, the Extension Ecosystem Summit EU on Tuesday, October 22, at the Divani Caravel Hotel in Athens.
Gülçin Yıldırım Jelínek: RAG app with Postgres and pgvector
Grant Fritchey: RDS Connectivity
I travel quite a lot for work. Most of it is in the US and Europe, but I get around to other places as well. Most of the time, connectivity, while not the greatest, isn’t that bad, or hard. I run a VPN on my phone and laptop. I can set up my RDS connectivity […]
The post RDS Connectivity appeared first on Grant Fritchey.
Andreas 'ads' Scherbaum: Yurii Rashkovskii
Floor Drees: Contributions of w/c 2024-09-30 (week 40)
- Dirk Krautschick and Christian Gohmann organized the 3. PostgreSQL User Group NRW MeetUp. Christoph Mönch-Teggeder and Christoph Berg presented at the Meetup.
- Gülçin Yıldırım Jelinek organized the Prague PostgreSQL Meetup: September Edition.
Jimmy Angelakos: Contributions of w/c 2024-09-23 (week 39)
- Melanie Plageman ran a mentorship feedback session and was the guest on episode 19 of Talking Postgres with Claire Giordano.
Douglas Hunley: Automating Highly Available PostgreSQL Clusters
Umair Shahid: Transitioning from Oracle to PostgreSQL: Tablespaces
Tablespaces play an important role in database management systems, as they determine where and how database objects like tables and indexes are stored. Both Oracle and PostgreSQL have the concept of tablespaces, but they implement them differently based on the overall architecture of each database.
The post Transitioning from Oracle to PostgreSQL: Tablespaces appeared first on Stormatics.
Amit Kapila: Failover Slots in PostgreSQL-17: Ensuring High Availability with Logical Replication
With the introduction of failover slots in PostgreSQL-17, logical replication can now be effectively utilized in high-availability environments. This feature ensures that logical replication continues seamlessly even if the publisher node fails and its physical standby is promoted as the new publisher.
To maintain continuous replication after a failover, you need to configure the following parameters and options for both logical and physical replication setups:
1. Enable Failover Property on Slots:
Gülçin Yıldırım Jelínek: Recap of OSS Vienna: What is Happening in the Open Source World
Andrei Lepikhov: PostgreSQL 'VALUES -> ANY' transformation
As usual, this project was prompted by multiple user reports with typical complaints, like 'SQL server executes the query times faster' or 'Postgres doesn't pick up my index'. The underlying issue that united these reports was frequently used VALUES sequences, typically transformed in the query tree into an SEMI JOIN.
Nikolay Samokhvalov: AI-assisted Postgres experiment: number of partitions vs. planning time
In one of the recent PostgresFM episodes, Michael Christofides and Nikolay discussed planning time and what can affect it. One of the obvious negative factors we've discussed is the large number of partitions a partition table might have.
In this post, we're using our Postgres.AI assistant to see how planning time depends on the number of partitions.
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 18 – Add temporal FOREIGN KEY contraints
Adam Hendel: Announcing ParadeDB partnership: Search and Analytics for Postgres
Luca Ferrari: PostgreSQL adds the login type for event triggers
Is it now possible to catch a login event.
PostgreSQL adds the login type for event triggersPostgreSQL 17 adds a new firing event for event triggers: login. Therefore it is now possible to catch a login attempt on a database.
Caution: this is not the same as Oracle logon triggers, even if it resembles the same functionality to me.
However, thanks to this, is is now possible to get some more information when a login attempt succeeds.
Luca Ferrari: PostgreSQL 17 allow_alter_system tunable
PostgreSQL 17 includes a new (among others) tunable to control the ALTER SYSTEM command.
PostgreSQL 17 allow_alter_system tunableAmong the new excellent features of PostgreSQL 17, one captured my attention: the capability to disable the ALTER SYSTEM command via the tunable [allow_alter_system](https://www.postgresql.org/docs/current/runtime-config-compatible.html#GUC-ALLOW-ALTER-SYSTEM){:target="_blank"}.