Month: July 2019
Composite/ combined indexes vs. separate indexes in PostgreSQL
A “composite index”, also known as “concatenated index” or a combined index, is an index on multiple columns in a table. Many people wonder what is more beneficial: Using separate or using composite indexes? Whenever we do training, consulting or support this question is high up on the agenda and many people keep asking this […]
PostgreSQL: How are functions and stored procedures replicated?
When looking at our PostgreSQL support activities, we notice that people often ask about functions, stored procedures and replication. Are functions replicated? How are functions replicated? What happens to shared libraries and do we have to install an extension everywhere? These topics seems to be really interesting to many people and so I decided to […]
The mysterious “backend_flush_after” configuration setting
By Kaarel Moppel – The “backend_flush_after” PostgreSQL server configuration parameter was introduced some time ago, in version 9.6. It has been flying under the radar, and had not caught my attention previously. However, I recently was pasted (not being on Twitter) a tweet from one of the Postgres core developers Andres Freund. The tweet basically […]
Implementing Autonomous Transactions in Postgres
BY Kaarel Moppel – Having recently witnessed quite an ingenious hack to implement some good old “println” style development debugging from stored procedures into a file, it prompted me to post knowledge to the Interwebs on two other ways how such a goal can be implemented more transparently. Also, with help of some other good […]
ICU collations against PostgreSQL data corruption
(Updated 2023-07-18) This article was prompted by version 2.28 of the GNU C library, which changed the definition of many collations. Such a change has the potential to cause data corruption in PostgreSQL. I will describe the problem and point out how ICU collations can solve it. The problem is not limited to glibc […]
Building PostgreSQL (x86, x64) and OpenSSL using MSYS2 and MinGW under Windows
I’ve written already a blog post “Building PostgreSQL with MSYS2 and MinGW under Windows” a year ago. But this time I want to show you two important things: cross compiling (x86, x64) using the same run-time; compiling with the latest OpenSSL support. That’s true nowadays you won’t find binaries or installations of PostgreSQL without […]
PostgreSQL meets “Data Science and AI”
Machine Learning, Deep Learning, Artificial Intelligence, and Data Science have become really important topics these days. Everybody is looking for new technologies and tries to make use of those recent developments. PostgreSQL can help to achieve those goals, and it offers reliable backend storage for your data. PostgreSQL vs. CSV files vs. commercial databases In […]