Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 1 Stunde 35 Minuten

Anna Bellandi: Barman Cloud – Part 2: Cloud Backup

16. Juli 2020 - 12:40
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 […]

Bruce Momjian: GROUPING SETs and NULL Values

15. Juli 2020 - 15:45

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:

Kaarel Moppel: pgwatch2 v1.8.0 released

15. Juli 2020 - 9:45

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!

Jonathan Katz: How to SCRAM with pgBouncer

14. Juli 2020 - 16:15

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.

Bruce Momjian: JSONB: A Container of Types

13. Juli 2020 - 20:00

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:

Michael Christofides: EXPLAIN glossary

13. Juli 2020 - 17:47

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.

Andreas 'ads' Scherbaum: Stacey Haysler

13. Juli 2020 - 15:00
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.

Luca Ferrari: PostgreSQL 13 Beta 2: it's your time to help testing!

13. Juli 2020 - 2:00

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

David Z: A simple way to trace a bug

11. Juli 2020 - 6:46
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.

Magnus Hagander: PGConf.EU 2020 - Conference canceled

10. Juli 2020 - 22:55

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

Bruce Momjian: Two Interviews

10. Juli 2020 - 16:30

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.

Luca Ferrari: PostgreSQL 12 Coin (by PGUS)

9. Juli 2020 - 2:00

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!

Luca Ferrari: replace vs regexp_replace

9. Juli 2020 - 2:00

Some considerations about the usage of replace or regexp_replace.

Bruce Momjian: Postgres Marketing

8. Juli 2020 - 18:00

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:

Liaqat Andrabi: Migration to PostgreSQL [Webinar]

8. Juli 2020 - 12:18
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 […]

Pavlo Golub: pg_timetable: start-up improvements

8. Juli 2020 - 9:00

¡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.

James Chanco: Getting Started with PostgreSQL Operator 4.3 in OpenShift

7. Juli 2020 - 20:12

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.

Anthony Sotolongo León: Generated Columns vs. Triggers in PostgreSQL 12

7. Juli 2020 - 14:00
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.

Andreas 'ads' Scherbaum: Kohei Kaigai

6. Juli 2020 - 16:00
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.

Hamid Akhtar: Features In PG13 – Deduplication in B-Tree Indexes

6. Juli 2020 - 9:14

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.