Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 59 Minuten 27 Sekunden

Luca Ferrari: PostgreSQL Extension Catalogs

20. Juli 2021 - 2:00

How to see the available and/or installed extensions?

PostgreSQL Extension Catalogs

There are three main catalogs that can be useful when dealing with extensions:

Paul Ramsey: Waiting for PostGIS 3.2: ST_MakeValid

19. Juli 2021 - 17:01

One of the less visible improvements coming in PostGIS 3.2 (via the GEOS 3.10 release) is a new algorithm for repairing invalid polygons and multipolygons.

Andreas 'ads' Scherbaum: Rafia Sabih

19. Juli 2021 - 16:00
PostgreSQL Person of the Week Interview with Rafia Sabih: I am basically from India, currently living in Berlin, Germany. I started my PostgreSQL journey in my masters and continued it by joining EDB, India. Then, I increased my spectrum to Postgres on Kubernetes working at Zalando.

Paolo Melchiorre: Maps with Django (part 2): GeoDjango, PostGIS and Leaflet

19. Juli 2021 - 0:00

A quickstart guide to create a web map with the Python-based web framework Django using its module GeoDjango, the PostgreSQL database with its spatial extension PostGIS and Leaflet, a JavaScript library for interactive maps.

Hubert 'depesz' Lubaczewski: Display “settings” from plans on

18. Juli 2021 - 20:07
Some time ago I wrote about new options for explains – one that prints settings that were modified from default. This looks like this: Aggregate (cost=35.36..35.37 rows=1 width=8) -> Index Only Scan using pg_class_oid_index on pg_class (cost=0.27..34.29 rows=429 width=0) Settings: enable_seqscan = 'off' Finally, today, I pushed a change that displays them on To … Continue reading "Display “settings” from plans on"

Amit Kapila: Logical Replication Of In-Progress Transactions

17. Juli 2021 - 14:16

Logical Replication was introduced in PostgreSQL-10 and since then it is being improved with each version. Logical Replication is a method to replicate the data selectively unlike physical replication where the data of the entire cluster is copied. This can be used to build a multi-master or bi-directional replication solution. One of the main differences as compared with physical replication was that it allows replicating the transaction only at commit time. This leads to apply lag for large transactions where we need to wait to transfer the data till the transaction is finished.

Dinesh Chemuduru: CentOS vs Rocky Linux Benchmark with PostgreSQL

17. Juli 2021 - 0:38

In December 2020, you might have seen an article from CentOS about shifting their focus towards CentOS stream, which is the upstream version of the RHEL. CentOS also mentioned that the version 8 would be EOL (end of life) by the end of the 2021. This means that it will no longer receive any updated fixes from it's upstream version of RHEL.

Pavel Stehule: pspg 5.1.0 was released, psql \watch command now supports pspg

16. Juli 2021 - 12:48
Today I released pspg 5.1.0. Mostly this is bugfix and refactoring release, but there is one, I hope, interesting function. You can try to press Ctrl o for temporal switch to terminal's primary screen. In primary screen you can see psql session.

Hubert 'depesz' Lubaczewski: How to get list of elements from multiranges?

15. Juli 2021 - 14:12
So, some time ago, Pg devs added multi ranges – that is datatype that can be used to store multiple ranges in single column. The thing is that it wasn't really simple how to get list of ranges from within such multirange. There was no operator, no way to split it. A month ago Alexander … Continue reading "How to get list of elements from multiranges?"

Aya Iwata: Improved logging by libpq in PostgreSQL 14

15. Juli 2021 - 3:04

The usability of the libpq feature to trace application's server/client communications has been enhanced in PostgreSQL 14, with an improved format and an option to control output.

Luca Ferrari: How much data goes into the WALs? (part 2)

15. Juli 2021 - 2:00

I did some more experiments with WALs.

Egor Rogov: Locks in PostgreSQL: 3. Other locks

15. Juli 2021 - 2:00

We've already discussed some object-level locks (specifically, relation-level locks), as well as row-level locks with their connection to object-level locks and also explored wait queues, which are not always fair.

Paul Ramsey: Generating JSON Directly from Postgres

14. Juli 2021 - 18:18

Too often, web tiers are full of boilerplate that does nothing except convert a result set into JSON. A middle tier could be as simple as a function call that returns JSON. All we need is an easy way to convert result sets into JSON in the database.

Hans-Juergen Schoenig: PostgreSQL: LIMIT vs FETCH FIRST ROWS … WITH TIES

14. Juli 2021 - 10:00

Most people in the SQL and in the PostgreSQL community have used the LIMIT clause provided by many database engines. However, what many do not know is that LIMIT / OFFSET are off standard and are thus not portable. The proper way to handle LIMIT is basically to use SELECT … FETCH FIRST ROWS. However, there is more than meets the eye.

Neil Chen: First contact with the pg_filedump

14. Juli 2021 - 4:34

During my most recent expedition of going through PostgreSQL source code, I ran into some mysterious variables in the page structure of some indexes. I will explain later why i am calling these mysterious but first have a look at these variables…

typedef struct HashPageOpaqueData
uint16 hasho_page_id; /* for identification of hash indexes */
} HashPageOpaqueData;


Luca Ferrari: How much data goes into the WALs?

13. Juli 2021 - 2:00

What is the amount of traffic generated in the Write Ahead Logs?

Michał Mackiewicz: What happens to logical replication after running pg_upgrade?

12. Juli 2021 - 18:51

Even if logical replication is a method of major upgrade itself, sometimes you’ll want to mix and match them. Consider the following scenario: a big and busy database that has a logical replica, which has its specific tables and indexes. When it’s time to upgrade, you will probably want to upgrade both instances – the publisher and the subscriber. As the database is big an busy, using logical replication itself or dump-and-restore aren’t the best choices – those methods will require massive amount of storage, and dump-and-restore will also require a long period of downtime.

Andreas 'ads' Scherbaum: Jean-Christophe Arnu

12. Juli 2021 - 16:00
PostgreSQL Person of the Week Interview with Jean-Christophe Arnu: Hi, I’m Jean-Christophe. I live in the south of France, near Toulouse. As far as I can remember, I have always been interested in computer science and programming. I moved a lot when I was a child but I settled in the Toulouse area when I started university. I am the father of 3 children, which is my first full time job, my second being a PostgreSQL database consultant in a PostgreSQL and Cloud dedicated company (we all are remote workers): LOXODATA.

Alexey Lesovsky: pgSCV 0.7.0 released

12. Juli 2021 - 15:24

New pgSCV 0.7.0 has been released, with new features, bug fixes and minor improvements.

Weaponry Weaponry: pgSCV 0.7.0 released

12. Juli 2021 - 15:24

New pgSCV 0.7.0 has been released, with new features, bug fixes and minor improvements.