Neues vom PostgreSQL Planet

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

Andreas 'ads' Scherbaum: Michael Goldberg

20. September 2021 - 16:00
PostgreSQL Person of the Week Interview with Michael Goldberg: I’m from a small town located in the Ural mountains. In 1991 our family moved to Israel. I live in Tel Aviv since then.

David Z: A quick test for postgres_fdw batch insertion

18. September 2021 - 1:21
1. Overview

In my previous blog, I briefly walked through how the bulk/batch insertion was done for postgres_fdw in PG14. In this blog, I am going to run some basic tests to compare the performance for before and after the batch insertion was introduced in postgres_fdw, so that we can have a general idea about whether this feature makes any difference.

Onder Kalacı: What’s new in the Citus 10.2 extension to Postgres

17. September 2021 - 17:23

Citus 10.2 is out! If you are not yet familiar with Citus, it is an open source extension to Postgres that transforms Postgres into a distributed database—so you can achieve high performance at any scale. The Citus open source packages are available for download.

Lætitia AVROT: pglog, a flexible and simple log analyzer

17. September 2021 - 2:00
As a consultant, I have to analyze various databases daily. I need to be able to grasp what the major problems are quickly and find the best way to solve them. Analyzing logs is a very efficient way to find problems. I was frustrated with the existing tools as I couldn’t deep dive into a problem to find more accurate data related to that problem only. That’s where I decided to use SQL to analyze my customers' logfiles.

Michał Mackiewicz: Broken indexes after Linux upgrade

16. September 2021 - 11:15

Upgrading one’s operating system to new major version is an important system maintenance task and it’s usually a good thing. It brings new features, security improvements, access to newer packages and so on. Sometimes it doesn’t go that smoothly, for example the updated system will refuse to start. But upgrading the OS running a Postgres cluster and involving a glibc library version update, or migrating a database to another machine running another OS (and glibc) version poses a little known, but very significant risk…

Pavlo Golub: PostgreSQL schedulers: comparison table

16. September 2021 - 10:00

Hello, my name is Pavlo Golub, and I am a scheduler addict. That began when I implemented pg_timetable for PostgreSQL. I wrote a lot about it. In this post, I want to share the result of my investigations on the schedulers available for PostgreSQL.

Amit Kapila: Logical Replication Improvements In PostgreSQL-14

15. September 2021 - 13:51
In the upcoming release of PostgreSQL-14, we will see multiple enhancements in Logical Replication which I hope will further increase its usage. This blog is primarily to summarize and briefly explain all the enhancements in Logical Replication.
Decoding of large transactions:

Yugo Nagata: Tuple Duplicates Support in Incremental View Maintenance

15. September 2021 - 2:00

In the previous posts ([1], [2], [3]), I have explained the Incremental View Maintenance (IVM) that we are proposing as a new feature of PostgreSQL.

David Kohn: How percentile approximation works (and why it's more useful than averages)

14. September 2021 - 17:41

In my recent post on time-weighted averages, I described how my early career as an electrochemist exposed me to the importance of time-weighted averages, which shaped how we built them into TimescaleDB hyperfunctions.

Álvaro Hernández: Respecting the majority, questioning the status quo as a minority

14. September 2021 - 16:49
Respecting the majority, questioning the status quo as a minority

Yesterday, the PostgreSQL Core Team launched an unprecedented attack on Fundación PostgreSQL as a whole and individually against Alvaro Hernandez. Fundación PostgreSQL responded promptly.

Hans-Juergen Schoenig: PostgreSQL: Create indexes after bulk loading

14. September 2021 - 10:00

Over the years, many of our PostgreSQL clients have asked whether it makes sense to create indexes before – or after – importing data. Does it make sense to disable indexes when bulk loading data, or is it better to keep them enabled? This is an important question for people involved in data warehousing and large-scale data ingestion. So let’s dig in and figure it out:

Andreas 'ads' Scherbaum: Soumyadeep Chakraborty

13. September 2021 - 16:00
PostgreSQL Person of the Week Interview with Soumyadeep Chakraborty: My hometown is Kolkata, India and I have spent the majority of my life there, including 3 years in the tech industry. More recently I have been living in the United States: I lived in Long Island, NY for a year and a half. I have been living in San Jose, California for the past two years, working at VMware.

Pavel Stehule: bugfix release of pspg - 5.3.5

13. September 2021 - 7:14
you can download source code from

Álvaro Hernández: Postgres Core Team launches unprecedented attack against the Postgres Community

11. September 2021 - 19:32
Postgres Core Team launches unprecedented attack against the Postgres Community Being distributed is the key to the project’s resilience

One of the often cited advantages of the PostgreSQL project is its resiliency. Especially in the presence of rogue actors: being a distributed Community, it is hard to target any individual, group or entity and affect/disrupt the whole Community.

Regina Obe: PostGIS 3.2.0alpha1 Released

11. September 2021 - 2:00

The PostGIS Team is pleased to release the first alpha of the upcoming PostGIS 3.2.0 release.

brian davis: RDS, Aurora Release Dates

10. September 2021 - 22:00

Below are the dates of Postgres major version releases and when they first became available on RDS and Aurora.

Useful for gaining a leg up in your office AWS Managed Postgres Major Version Release Date betting pool.

Brandur Leach: Postgres: Boundless `text` and Back Again

10. September 2021 - 17:55

One of the major revelations for almost every new user to Postgres is that there’s no technical advantage of specifying columns as varchar(n) compared to just using bound-less text. Not only is the text type provided as a convenience (it’s not in the SQL standard), but using it compared to constrained character types like char and varchar carries no performance penalty. From the Postgres docs on character type (and note that character varying is the same thing as varchar):

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 15 – Revoke PUBLIC CREATE from public schema, now owned by pg_database_owner.

10. September 2021 - 11:28
On 10th of September 2021, Noah Misch committed patch: Revoke PUBLIC CREATE from public schema, now owned by pg_database_owner.   This switches the default ACL to what the documentation has recommended since CVE-2018-1058. Upgrades will carry forward any old ownership and ACL. Sites that declined the 2018 recommendation should take a fresh look.

Luca Ferrari: Using jq to get information out of pgbackrest

10. September 2021 - 2:00

pgbackrest supports the JSON output format, and this can be useful to automate some information analysys.

Brandur Leach: How We Went All In on sqlc/pgx for Postgres + Go

8. September 2021 - 18:49

After a few months of research and experimentation with running a heavily DB-dependent Go app, we’ve arrived at the conclusion that sqlc is the figurative Correct Answer when it comes to using Postgres (and probably other databases too) in Go code beyond trivial uses. Let me walk you through how we got there.

First, let’s take a broad tour of popular options in Go’s ecosystem: