Neues vom PostgreSQL Planet

The PostGIS Team is pleased to release PostGIS 3.5.0alpha2! Best Served with PostgreSQL 17 Beta2 and GEOS 3.12.2.

Some great news: there's a new European PostgreSQL event in the Netherlands taking place in Amsterdam in September: PGDay Lowlands 2024!

This post contains the slides from the talk that I gave at Brighton Ruby last week, along with the transcript and other information.

I'll add the link to the video as soon as it's available.

The PostGIS Team is pleased to release PostGIS 3.5.0alpha1! Best Served with PostgreSQL 17 Beta2 and GEOS 3.12.2.

This version requires PostgreSQL 12 - 17, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. To take advantage of all SFCGAL features, SFCGAL 1.5.0+ is needed.

Learn how to configure key parameters to boost Transactions Per Second (TPS) and improve overall database performance.

The post Key PostgreSQL Configuration Parameters for Enhanced Performance appeared first on Stormatics.

I enjoy writing about the technical aspects of PostgreSQL, but occasionally it is good to write about other aspects of PostgreSQL. Since I just returned from the Swiss PGDay 2024, I'll sing the praise of PostgreSQL conferences.

Ever been fascinated by the limitless possibilities that PostgreSQL extensions bring to the table? From enhancing security to driving machine learning capabilities, extensions elevate the functionality of your database, transforming it into a powerful tool that drives business success. Imagine effortlessly querying and connecting to diverse sources like MySQL, Oracle, and Storing Embedding usinf vector data type and many more—all made possible through extensions.

Among the novelties of PostgreSQL 17, recently released in beta, there’s a built-in UTF-8 locale and collation with binary string comparisons. In this post, let’s see why it’s interesting, how to use it and how it performs.

PostgreSQL Person of the Week Interview with Dilip Kumar: My name is Dilip Kumar, and I reside in Bangalore, India. I am recognized as a PostgreSQL contributor, having made significant contributions to the core features of the PostgreSQL open-source project, mainly in areas of Parallel Query, Logical replication, Performance improvements, and SLRU.

This post contains the slides from the talk that I gave at PGConf.dev in Vancouver a few weeks ago, together with the transcript and other information.

This is my new approach to sharing slides, inspired by Simon Willison's annotated presentations.

You can also watch the video here.

This post debates the current sort cost model, identifies its shortcomings, and proposes a new, more comprehensive model that expands the scope of the optimiser search. Designing this post for developers, we've intentionally used terminology derived from PostgreSQL internal code, which may sometimes be unclear to newcomers.

Hey there! My book High Performance PostgreSQL for Rails just went into print last week!

As part of celebrating this milestone, we’ve got a series of promotional appearances lined up to explore Ruby on Rails and PostgreSQL in general and help explain why prospective readers may benefit from the book.

To kick things off, I recently met with Phil Smy who runs a popular YouTube channel with videos on Ruby on Rails and more.

Cut the number of required PostgreSQL server round-trips by up to 50% using the `AND CHAIN` parameter of the `COMMIT` and `ROLLBACK` statements.

TL;DR: If you’re a Postgres extension developer interested in understanding what to expect from core API and ABI stability, please review and give feedback on this patch (or pull request) adding ABI and API Guidance to the documentation.

Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put together an interesting collection of data over on GitHub. It’s titled DBA Resources, but it goes beyond DBAs. It’s much more about the different data platforms on display. And, it’s in Github. Create a pull request and you can add to […]

The post Data Technology Learning Resources appeared first on Grant Fritchey.

The upcoming CloudNativePG 1.24 introduces a game-changing feature: the ability to declaratively manage PostgreSQL cluster switchover across cloud regions or different Kubernetes clusters. This advancement enables the seamless demotion of a primary cluster and the promotion of a replica cluster in another region without the need to re-clone the former primary. This innovation significantly revolutionises database management practices, enhancing efficiency and reliability in multi-region and multi-cluster environments.

This article outlines how to rebuild indexes with `REINDEX`. As an example, we will deliberately corrupt an index for a column that uses a custom `ENUM` column.

Let's say you have two rasters, and you want to combine them with some extra value math -- perhaps you want to grade grassland around 50°N 100°E by latitude and elevation, so blue to green to red the more northerly or higher up the point. ST_MapAlgebra to the rescue!

As a PostgreSQL developer, I am inevitably stumbling across some weak points in the code. I’m not sure alternative DBMSes manage that much better, but knowledge about possible issues may help in the long run.

This time, I encountered quite a subtle issue - incremental sort estimation instability.

An option I was not aware of…

pg_dump and –if-exists little gem

pg_dump is a very useful tool to dump (and hence prepare to restore) a single PostgreSQL database.

When I use it, I usually add the options: