Neues vom PostgreSQL Planet

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:

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.

PostgreSQL Person of the Week Interview with Kohei Kaigai: I grew up in Shiga, Japan. It is known as the lake-side area of the greatest lake in our nation. I studied computer science and business administration at the University of Tsukuba. After that, I started my first career at NEC, as a developer of Linux kernel.

PG13; not to be confused with PG-13, only PostgreSQL Guidance required here!

PostgreSQL Beta 1 was released on May 21, 2020 and Beta 2 on June 25, 2020. A beta might not be bug free, but it almost always includes all core features of the full release. PG betas are no different. Beta 2 includes all the major features we expect to see in the final release. There are some fairly useful and exciting features that are worth mentioning.

On June 17th, I gave a presentation on Postgres Monitoring to the Chicago Postgres User Group. Since MeetUp doesn’t allow uploading slides, I figured I’d convert my presentation into a more comprehensive writeup. Enjoy! Why Monitor So, what are the finer points of Disaster Mitigation? Let’s start with a few questions: What broke? When did […]

For btree and hash indexes to be used for lookups, values being requested must be very restrictive, roughly 3-5% of a table's rows. Let's consider a BOOLEAN column — it can contain only three values: true, false, and NULL.