Neues vom PostgreSQL Planet

The traditional method of authenticating is local password. Authentication using external password managers is also very popular. However, passwords have known limitations, particularly password selection.

In this blog series, we have covered the following machine learning models to utilize Machine Learning capabilities with 2UDA. KNN SVM Random Forest Tree Logistic Regression AdaBoost Neural Network Now we are bringing you a recap of this blog series in order to summarize the results we obtained through these models in a single post. […]

In the first part of this blog, Jonathan explained how the barman-wal-archive command works. Now, assuming you followed those instructions, you have a properly configured PostgreSQL instance up and running. In this second part, I will show you how the barman-cloud-backup command works. As you can guess from the command name itself, the barman-cloud-backup command […]

You might be aware that GROUPING SETS, along with ROLLUP and CUBE, allow queries to return additional GROUP BY rows. However, because these additional rows are added by Postgres, it is unclear what value to use for summary fields, so the SQL standard specifies NULL for those fields. Let's start with a simple example using a simple GROUP BY:

After exactly half a year (seems to be a pattern already) since the last major release of pgwatch2 Open Source PostgreSQL monitoring tool, I’m glad to announce that another set of useful features and improvements have found their way into the pgwatch2 code repository!

I've made it no secret that I am a huge fan of PostgreSQL's SCRAM support: it provides a secure, standardized way of performing authentication with passwords, and is a method that can be universally applied.

The popular JSON and JSONB data types are more than just a collection of single-data-type values like arrays. They can contain multiple data types:

After a lot of time looking at query plans, we’re still coming across new operation types, fields, and terminology. Many of these terms were tricky to look up and understand, so we decided to share descriptions and useful links for many of the most common in a glossary.

PostgreSQL Person of the Week Interview with Stacey Haysler: I live in Alameda, California (a small island across the bay from San Francisco) with my husband. I’m the CFO and COO of PostgreSQL Experts, Inc.

We are approaching the great 13 release, help the team testing it!

1. Overview

Whenever I tried to study PostgreSQL source code a little deeper, I always wanted to find some tools to help me understand better as I really don’t want to read the code line by line for a particular feature, but at the same time, I really wanted to figure it out quickly. Simply put, I was kind of “lazy” at that movement. Luckily, I found one very simple way to help me when I was studying the Geometric Types in PostgreSQL. This simple method helped me find out a bug exist since 1997. Thanks to Tom Lane who helped fix it and committed it to PostgreSQL.

fter a long discussion, we have made the painful decision to cancel PostgreSQL Conference Europe 2020.

I have done two interviews in the past month. The first one was done by the Linux Inlaws and was published on Hacker Public Radio. This interview discusses the history and open source aspects of the Postgres project, and its health and future direction.

A very nice surpise in the mail!

PostgreSQL 12 Coin (by PGUS)

A couple of weeks ago I got a very nice surprise in the mail, but I was not able to write about it due to my eyes problems and current situation (a very few details can be found here).
Anyway, promoting PostgreSQL is important, so here I am to tell you about what I received.

Long story short: I received a PostgreSQL 12 celebrative coin!

Some considerations about the usage of replace or regexp_replace.

Postgres is mostly a technology-driven community, so marketing often suffers. However, one great thing about the community is that it is distributed, so anyone can get involved and help. Here are some examples of very successful community-driven marketing ideas:

Among the many reasons to Migrate to PostgreSQL, dedicated support and seamless transition are key drivers for a business considering migration. Being open-source software, PostgreSQL provides a highly reliable, stable, scalable, and secure database migration, keeping in mind the unique needs of every business. Migration to PostgreSQL, however, can still be an extensive process as […]

¡Hola, queridos amigos! We’ve released several valuable features for pg_timetable in May. It’s summer already, and time is flying fast! I hope all of you are well and safe, as well as your families and friends.

The first step of working with any software is getting it installed. Based on your environment, this could be as easy as a one-click installer, or require a manual that's hundreds of pages long with thousands of config bits to tune. Deploying complex applications on Kubernetes and OpenShift can often fall somewhere in the middle.

A comparative approach between Generated Columns and Triggers

In this post, we are going to describe how Generated Colums work and how much it improves query execution times, compared to trigger-based solutions.

For the test set, we analyzed the performance of INSERT and UPDATE operations using Generated Columns against C and PL/pgSQL based function triggers.