Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 10 Minuten 42 Sekunden

Greg Sabino Mullane: Enhanced Postgres Release Notes

9. Oktober 2024 - 23:30

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

9. Oktober 2024 - 19:14

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

9. Oktober 2024 - 18:26

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

9. Oktober 2024 - 17:27

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

8. Oktober 2024 - 9:17
Build a RAG app using Postgres and pgvector to enhance AI applications with improved data management, privacy, and efficient local LLM integration.

Grant Fritchey: RDS Connectivity

7. Oktober 2024 - 16:04

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

7. Oktober 2024 - 16:00
PostgreSQL Person of the Week Interview with Yurii Rashkovskii: I was born and raised in Ukraine, and moved to Canada in 2008 without knowing much about it. I wanted to go as far west as I could to explore. That move changed my life a lot, and I now live on beautiful Vancouver Island in British Columbia.

Jimmy Angelakos: Contributions of w/c 2024-09-23 (week 39)

6. Oktober 2024 - 2:54

Douglas Hunley: Automating Highly Available PostgreSQL Clusters

4. Oktober 2024 - 16:07
In March of ‘23, I took over as the Lead Architect of my employer’s Ansible-based automation for creating highly-available PostgreSQL clusters.

Umair Shahid: Transitioning from Oracle to PostgreSQL: Tablespaces

4. Oktober 2024 - 10:07

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

4. Oktober 2024 - 7:51

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

4. Oktober 2024 - 2:00
My notes from the Open Source Summit Europe in Vienna, featuring fresh updates from open source communities, insights from the Xata booth, and highlights from our Postgres Happy Hour

Andrei Lepikhov: PostgreSQL 'VALUES -> ANY' transformation

4. Oktober 2024 - 1:58
Introduction

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

3. Oktober 2024 - 23:45

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

3. Oktober 2024 - 20:19
On 17th of September 2024, Peter Eisentraut committed patch: Add temporal FOREIGN KEY contraints   Add PERIOD clause to foreign key constraint definitions. This is supported for range and multirange types. Temporal foreign keys check for range containment instead of equality.   This feature matches the behavior of the SQL standard temporal foreign keys, but … Continue reading "Waiting for PostgreSQL 18 – Add temporal FOREIGN KEY contraints"

Adam Hendel: Announcing ParadeDB partnership: Search and Analytics for Postgres

3. Oktober 2024 - 11:00
This post contained content that could not be rendered in the Atom feed. Please use the official post link: https://tembo.io/blog/paradedb-search-analytics

Luca Ferrari: PostgreSQL adds the login type for event triggers

3. Oktober 2024 - 2:00

Is it now possible to catch a login event.

PostgreSQL adds the login type for event triggers

PostgreSQL 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

3. Oktober 2024 - 2:00

PostgreSQL 17 includes a new (among others) tunable to control the ALTER SYSTEM command.

PostgreSQL 17 allow_alter_system tunable

Among 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"}.

Tomas Vondra: [PATCH IDEA] parallel pgbench -i

1. Oktober 2024 - 12:00

There are multiple tools to run benchmarks on Postgres, but pgbench is probably the most widely used one. The workload is very simple and perhaps a bit synthetic, but almost everyone is familiar with it and it’s a very convenient way to do quick tests and assessments. It was improved in various ways (e.g. to do partitioning), but the initial data load is still serial - only a single process does the COPY. Which annoys me - it may take a lot of time before I can start with the benchmarks itself.

Laurenz Albe: What's so great about PostgreSQL v17?

1. Oktober 2024 - 8:00


© Laurenz Albe 2024

Every year in fall, there is a new PostgreSQL release. After looking at the highlights of PostgreSQL v17, you may think, “what's the big deal?” Quite a few people might even be unhappy about the reminder that they should really upgrade some time soon. Time to explain how wonderful PostgreSQL v17 is!

Seiten