Neues vom PostgreSQL Planet

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

Peter Eisentraut: GQL:2024 is out

17. April 2024 - 6:00

The news today is that GQL:2024, the first version of the GQL standard, has been published by ISO. GQL is a new language for graph databases, like SQL is for relational databases.

Here is the link to it on the ISO web site:

This is the culmination of work that has been going on formally within ISO since 2019 and for several years more before that in preparation. (There was even a manifesto! How can you go wrong?)

Henrietta Dombrovskaya: PostgreSQL 17 features I am most waiting for

17. April 2024 - 2:58

I won’t be able to attend Magnus’ talk at PG Day Chicago because it is scheduled at the same time as my talk, but fortunately, I attended his talk at SCaLe. There are several features I am really excited about, and I can’t wait to start using them!

Gabriele Bartolini: CloudNativePG Recipe 7: Postgres Vertical Scaling with Storage in Kubernetes - part 2

16. April 2024 - 10:24

This is the second article in a series that explores advanced strategies for scaling PostgreSQL databases in Kubernetes with the help of CloudNativePG. This article focuses on horizontal table partitioning and tablespaces and how they can be used to manage large datasets. By partitioning tables based on specific criteria and optimising storage with tablespaces, PostgreSQL users can achieve better scalability and performance in cloud-native environments, just like they could in traditional VMs or bare metal deployments.

Andrew Atkinson: Use Cases for Merging and Splitting Partitions With Minimal Locking in PostgreSQL 17

16. April 2024 - 2:00

This post looks at some interesting new capabilities managing Partitioned Tables coming in PostgreSQL 17, expected for release Fall 2024. The current major version is 16.

Current Table Partition Commands

Prior to Version 17, workflow options for partition management are limited to creating, attaching, and detaching partitions.

Once we’ve designed our partition structure, we couldn’t redesign it in place.

Adam Hendel: Operationalizing Vector Databases on Postgres

15. April 2024 - 20:00

Why do we need vector databases? The proliferation of embeddings immediately brought forth the need to efficiently store, index, and search these arrays of floats. However, these steps are just a small piece of the overall technology stack required to make use of embeddings. The task of transforming source data to embeddings and the serving of the transformer models that make this happen is often left as a task to the application developer. If that developer is part of a large organization, they might have a machine learning or data engineering team to help them.

David Wheeler: Mini Summit: Jonathan Katz on TLEs

15. April 2024 - 17:22

Coming up this week: the fourth installment of the Postgres extension ecosystem mini-summit. The topic: Trusted Language Extensions, a.k.a. TLEs.

Manisankar Kanagasabapathy: Rebuilding Tables online using pg_repack in PostgreSQL

15. April 2024 - 10:01

Any database engine, including PostgreSQL, requires some routine maintenance to ensure optimal performance. Especially when there are massive delete or purge operations to delete rows from a Table, the fragmentation builds up within a table. Reclaim this fragmented space from disk requires a table to be rebuilt. At HexaCluster, we had many Customers asking us […]

Denis Laxalde: Improved query cancellation in PostgreSQL 17 and Psycopg 3.2

15. April 2024 - 7:00

Toulouse, 15 April 2024

The upcoming PostgreSQL 17 will ship with improved query cancellation capabilities, as part of the libpq, and so will the upcoming release of Psycopg version 3.2.

About a month ago, Alvaro Herrera committed the following patch to PostgreSQL:

Luca Ferrari: pgenv: run once scripts

15. April 2024 - 2:00

A new feature to run a single script at the very beginning of the cluster lifecycle.

pgenv: run once scripts

Today pgenv got a new release that provides a simple, but quite useful, feature: the capability to run a custom script the first time the instance is started.

Andrew Atkinson: 🎙️ Hacking Postgres 🐘 Podcast - Season 2, Ep. 1 - Andrew Atkinson

15. April 2024 - 2:00

Recently I joined Ry Walker, CEO of Tembo, as a guest on the Hacking Postgres podcast.

Hacking Postgres has had a lot of great Postgres contributors as guests on the show, so I was honored to be a part of it being that my contributions are more in the form of developer education and advocacy.

Ry asked me about when I got started with PostgreSQL and what my role looks like today.

Luca Ferrari: PostgreSQL 16 Coin

14. April 2024 - 2:00

I just got the coin in the mail!

PostgreSQL 16 Coin

I just received in the mail the PostgreSQL 16 Coin with a great artwork!

I’m really happy to be part of this great community!

Shaun M. Thomas: PG Phriday: Under Observation

12. April 2024 - 18:30

Have you ever wanted to use a non-superuser role in a Postgres database to perform actions that are normally restricted? Even something as simple as reading from the pg_stat_activity view requires special permissions to view the query column because it could contain sensitive information.

Hubert 'depesz' Lubaczewski: Waiting for …: SQL/JSON is coming back. Hopefully.

12. April 2024 - 13:28
This is not the usual Waiting for post, but something should be said. Back in March/April of 2022 Andres Dunstan committed a series of patches that added support for lots of really interesting features from SQL/JSON standard. While I'm not avid user of json in database, I was very, very happy. Wrote couple of blogposts … Continue reading "Waiting for …: SQL/JSON is coming back. Hopefully."

Deepak Mahto: PL/pgSQL Conversion Gotchas: Cursors and Last Fetch.

12. April 2024 - 7:18

Databases Cursors are one of the key components of development. We have been using them for traversing query results for processing based on business logic or functionality. In Code Conversion, Cursor code always needs to be ported either from PL\SQL or TSQL to Pl\pgSQL, and some special considerations need to be incorporated as best practices to avoid surprises or functionality failures.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Invent SERIALIZE option for EXPLAIN.

11. April 2024 - 21:51
On 3rd of April 2024, Tom Lane committed patch: Invent SERIALIZE option for EXPLAIN.   EXPLAIN (ANALYZE, SERIALIZE) allows collection of statistics about the volume of data emitted by a query, as well as the time taken to convert the data to the on-the-wire format. Previously there was no way to investigate this without actually … Continue reading "Waiting for PostgreSQL 17 – Invent SERIALIZE option for EXPLAIN."

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Add new COPY option LOG_VERBOSITY.

11. April 2024 - 21:38
On 1st of April 2024, Masahiko Sawada committed patch: Add new COPY option LOG_VERBOSITY.   This commit adds a new COPY option LOG_VERBOSITY, which controls the amount of messages emitted during processing. Valid values are 'default' and 'verbose'.   This is currently used in COPY FROM when ON_ERROR option is set to ignore. If 'verbose' … Continue reading "Waiting for PostgreSQL 17 – Add new COPY option LOG_VERBOSITY."

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Add support for MERGE … WHEN NOT MATCHED BY SOURCE.

11. April 2024 - 21:26
On 30th of March 2024, Dean Rasheed committed patch: Add support for MERGE ... WHEN NOT MATCHED BY SOURCE.   This allows MERGE commands to include WHEN NOT MATCHED BY SOURCE actions, which operate on rows that exist in the target relation, but not in the data source. These actions can execute UPDATE, DELETE, or … Continue reading "Waiting for PostgreSQL 17 – Add support for MERGE … WHEN NOT MATCHED BY SOURCE."

Marcelo Altmann: Mastering Query Rewriting for Faster PostgreSQL Performance

11. April 2024 - 20:29

When you first spin up your app, the emphasis is on getting started and getting data to your clients. But when you don’t have throughput, you are also not going to have enough concurrency to unveil bad queries.

But then you have success. And success means data. More users, more interactions, more everything. Suddenly, queries that performed fine are struggling under the load, hurting performance and scalability. This is all going to mean a far worse user experience when much higher costs because of inefficient resource use.

Sai Srirampur: PeerDB raises $3.6 million seed funding to revolutionize data movement for PostgreSQL

11. April 2024 - 7:55
PeerDB offers a fast and cost-effective way to move data from PostgreSQL to data warehouses, such as Snowflake, and to queues like Kafka. This enables businesses to have real-time and reliable access to data, which is of utmost importance in this AI ...

Peter Eisentraut: PostgreSQL 17 commitfest conclusion

11. April 2024 - 6:00

Last October, I wrote:

Looking at the numbers in the PG17 cycle so far, even though they are much lower than the 2023-03 commitfest, we can expect that PG17 will have more activity in total than previous development cycles.

And now it’s time to count up the score. The final per-commitfest numbers of committed patches were: