Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 42 Minuten 13 Sekunden

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.

Nikolay Samokhvalov: What is a slow SQL query?

10. September 2021 - 0:18
Is 200 ms slow for an SQL query? What about 20 ms? When do we need to optimize?

Anatoly Stansler: What is a slow SQL query?

10. September 2021 - 0:18
Is 200 ms slow for an SQL query? What about 20 ms? When do we need to optimize?

Miranda Auhl: Speeding up data analysis with TimescaleDB and PostgreSQL

9. September 2021 - 17:32

Time-series data is everywhere, and it drives decision-making in every industry. Time-series data collectively represents how a system, process, or behavior changes over time.

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:

Laurenz Albe: Index bloat reduced in PostgreSQL v14

8. September 2021 - 10:00

© Laurenz Albe 2021

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

8. 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:

Ryan Lambert: Psycopg3 Initial Review

7. September 2021 - 5:15

If you use Postgres and Python together you are almost certainly familiar with psycopg2. Daniele Varrazzo has been the maintainer of the psycopg project for many years. In 2020 Daniele started working full-time on creating psycopg3, the successor to psycopg2. Recently, the Beta 1 release of psycopg3 was made available via PyPI install. This post highlights two pieces of happy news with psycopg3:

Andreas 'ads' Scherbaum: Akshay Joshi

6. September 2021 - 15:45
PostgreSQL Person of the Week Interview with Akshay Joshi: I am from India, born and brought up in Indore, but living in Pune since I joined EDB. I graduated with a Bachelor of Science in Computers, and post graduated with a Master of Computer Applications. I am married and have 2 kids - a 13 year old son and an 8 year old daughter.

Franck Pachot: Aurora PostgreSQL db.r6g compared to db.r5 with YBIO

6. September 2021 - 12:16

Here is a quick test I did after reading:

Regina Obe: PostGIS 3.1.4, 3.0.4 Released

4. September 2021 - 2:00

The PostGIS development team is pleased to provide bug fix and performance enhancements 3.1.4 and 3.0.4 for the 3.1, 3.0 stable branches.

3.1.4 This release supports PostgreSQL 9.6-14.

cary huang: Implement Foreign Scan With FDW Interface API

3. September 2021 - 22:57
1. Introduction

Recently I have been tasked to familiarize myself with the Foreign Data Wrapper (FDW) interface API to build a new FDW capable of doing vertical / columnar sharding, meaning that the FDW is capable of collecting column information from multiple sources and combine them together as a result query. I will document and blog about the vertical sharding in later posts. Now, in this blog, I would like to share some of the key findings and understanding of FDW interface related to foreign scan.

Richard Yen: When Less is More: Database Connection Scaling

3. September 2021 - 19:00
Why a high max_connections setting can be detrimental to performance Introduction

As a PostgreSQL Support Engineer, one common scenario we experience is a slow system on a reasonably powerful machine. In these cases, we often see that max_connections is set to 10,000 or more, sometimes even as high as 30,000. While we will advise that max_connections is too high and needs to be lowered, the usual response is, “Well, most of those connections are idle, so they shouldn’t affect performance.” This statement is not true, as an idle connection is not weightless.