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!
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.
We are approaching the great 13 release, help the team testing it!
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.
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:
¡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.
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.
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.