Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 48 Minuten 1 Sekunde

Martin Davis: Concave Hulls in JTS

18. Januar 2022 - 15:53

A common spatial need is to find a polygon that accurately represents a set of points.  The convex hull of the points often does not provide this, since it can enclose large areas which contain no points.  What is required is a non-convex hull, often termed the concave hull.  

Vik Fearing: pgDay Paris 2022 - pgDay Paris 2022 — Schedule published

18. Januar 2022 - 14:30

The pgDay Paris 2022 conference schedule has now been posted. Eight great sessions, eight great speakers with diverse perspectives, all in a single-track event so no one has to miss out on any of the presentations.

Space is limited at the event due to COVID-19 restrictions. Tickets can be purchased on the website.

Robert Haas: Surviving Without A Superuser - Part Two

18. Januar 2022 - 14:00

If PostgreSQL had the ability to give to a privileged non-superuser the right to administer objects belonging to some designated group of superusers just as if the privileged account were superuser, it would get us much closer to a world in which the database can be effectively administered by a non-superuser.

Andreas 'ads' Scherbaum: Kuntal Ghosh

17. Januar 2022 - 15:00
PostgreSQL Person of the Week Interview with Kuntal Ghosh: Hi, I am Kuntal, and I live in Bangalore, India. I’ve started exploring PostgreSQL during my Master Thesis, and continued it by joining EDB in India. Currently, I’m working at Amazon on Aurora Postgres.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 15 – Introduce log_destination=jsonlog

17. Januar 2022 - 12:46
On 17th of January 2022, Michael Paquier committed patch: Introduce log_destination=jsonlog   "jsonlog" is a new value that can be added to log_destination to provide logs in the JSON format, with its output written to a file, making it the third type of destination of this kind, after "stderr" and "csvlog". The format is convenient … Continue reading "Waiting for PostgreSQL 15 – Introduce log_destination=jsonlog"

Hubert 'depesz' Lubaczewski: Configuration changes across Pg versions

17. Januar 2022 - 11:45
Back in 2018 I wrote – aggregator of changelogs between various versions of Pg. Want to know what you will get when upgrading from 12.1 to 12.9? Here you go. Longer time changes? Like, from 9.5.20 to 14.1? I've got your back. It even has a way to list every change that relates to … Continue reading "Configuration changes across Pg versions"

Franck Pachot: Quick 📊 on 🐘 active SQL from pg_stat_activity

14. Januar 2022 - 16:08

pg_stat_statements can identify long queries, but are limited when we need to go further: the queries are normalized with values replaced by parameters. And the metrics gathered are cumulative, about time, with min, max, average, stddev, usually over a long time window. It is hard to catch the statements responsible for the activity at peak load, and when caught, not easy to reproduce the execution plan, know the user, or the application that ran it.

Nikolay Samokhvalov: Progress bar for Postgres queries – let's dive deeper

14. Januar 2022 - 8:11

Recently, I have read a nice post titled "Query Progress Bar", by Brian Davis. It describes an interesting approach to observing the progress of slow query execution.

At some point, the author mentions:

> Don't use this in prod.

Regina Obe: Upgrading raster from 2.* to 3.*

14. Januar 2022 - 1:00

As of PostGIS 3.0, the PostGIS raster support is no longer part of the postgis extension, but instead spun off into a new PostGIS extension called postgis_raster.

The two main reasons for this break were:

  • Raster functionality in PostGIS is fat with over 150 functions and several types. Wading through these extra functions frustrated many who had no use for rasters.

  • Raster gdal dependency is very big and many dreamed of having postgis extension without the big raster dependency.

Paul Ramsey: PostGIS 3.2 New and Improved

13. Januar 2022 - 19:23

Last month, just under the wire for a 2021 release, the 3.2 version of PostGIS hit the streets! This new PostGIS also supports the latest 3.10 release of GEOS, which underpins a few of the new features.

Jobin Augustine: How Patroni Addresses the Problem of the Logical Replication Slot Failover in a PostgreSQL Cluster

13. Januar 2022 - 14:31

Failover of the logical replication slot has always been the pain point while using the logical replication in PostgreSQL. This lack of feature undermined the use of logical replication and acted as one of the biggest deterrents. The stake and impact were so high that many organizations had to discard their plans around logical replication, and it affected many plans for migrations to PostgreSQL. It was painful to see that many had to opt for proprietary/vendor-specific solutions instead.

Robert Haas: Who Contributed to PostgreSQL Development in 2020 and 2021?

12. Januar 2022 - 14:00

I have done a few previous blog posts on who has contributed to PostgreSQL, but I did not do one last year. A couple people mentioned to me that they missed it, so I decided to do one this year, and I decided to gather statistics, using basically the same methodology that I have in the past, for both 2020 and 2021.

Claire Giordano: Why give a conference talk (or, why give a Postgres talk)

11. Januar 2022 - 18:35

If you’ve never done it before, you might be daunted by the idea of giving a conference talk. You know: the work involved, the butterflies, how to make it a good talk and not a boring one, the people who might judge you… And perhaps the hardest bit: choosing a topic others will find interesting.

Fernando Laudares Camargos: Creating a Standby Cluster With the Percona Distribution for PostgreSQL Operator

11. Januar 2022 - 16:39

A customer recently asked if our Percona Distribution for PostgreSQL Operator supports the deployment of a standby cluster, which they need as part of their Disaster Recovery (DR) strategy. The answer is yes – as long as you are making use of an object storage system for backups, such as AWS S3 or GCP Cloud Storage buckets, that can be accessed by the standby cluster.

Luca Ferrari: Pentagon numbers

11. Januar 2022 - 1:00

A couple of different solutions to an interesting problem.

Andreas 'ads' Scherbaum: Emil Shkolnik

10. Januar 2022 - 15:00
PostgreSQL Person of the Week Interview with Emil Shkolnik: I was born in Riga, Latvia and our family moved to Israel in 1990, since then I am here.

Avinash Vallarapu: A short summary of the Year 2021 in the PostgreSQL ecosystem

7. Januar 2022 - 22:37

On behalf of the PostgreSQL community and the team at MigOps, we wish all the readers a very Happy New Year - 2022. It is no wonder that PostgreSQL is the only Open Source database with a consistent increase in its adoption every year. The Year 2021 has been another milestone in the PostgreSQL world.

Shaun M. Thomas: PG Phriday: Defining High Availability in a Postgres World

7. Januar 2022 - 16:29
What does High Availability actually mean when we’re discussing Postgres clusters? Sure, we can set an RPO, RTO, SLA, and other 3-letter acronyms regarding expectations and deliverables, but what are we trying to achieve? Fast failover? No lost transactions? Both? What about time necessary to rebuild or reclaim a former Primary node? How do all of our various replication configurables affect this? Let’s see if we can come up with a definition of High Availability that’s suitable to a Postgres context. This may seem a trivial exercise at first, but there’s a method to our madness.

Lukas Fittl: Postgres in 2021: An Observer's Year In Review

7. Januar 2022 - 8:45
Every January, the pganalyze team takes time to sit down to reflect on the year gone by. Of course, we are thinking about pganalyze, our customers and how we can improve our product. But, more importantly, we always take a bird's-eye view at what has happened in our industry, and specifically in the Postgres community. As you can imagine: A lot! So we thought: Instead of trying to summarize everything, let's review what happened with the Postgres project, and what is most exciting from our…