Neues vom PostgreSQL Planet

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.