What you should know about PostgreSQL minor upgrades
by
Laurenz Albe |
12.2023© Laurenz Albe 2023 The PostgreSQL documentation is rather terse on the subject of minor upgrade. The reason is probably […]
LZ4 and ZSTD pg_dump compression in PostgreSQL 16
LZ4 and ZSTD pg_dump compression I wrote a "pg_dump compression specifications in PostgreSQL 16" post a while ago. Frankly speaking, […]
pg_dump compression specifications in PostgreSQL 16
What is pg_dump compression? pg_dump is a PostgreSQL utility for backing up a local or remote PostgreSQL database. It creates […]
Why are my PostgreSQL updates getting slower?
by
Laurenz Albe |
10.2022 Recently, a customer asked me why a bulk load into a PostgreSQL table kept slowing down as time went […]
PostGIS upgrade with Ubuntu 20.04.02
Last time, we installed PostGIS on top of PostgreSQL. Today, I will show you how to upgrade PostGIS on Ubuntu 20.04.02.
Upgrading and updating PostgreSQL
Update/ upgrade: what's the difference? This blog post covers the best ways of upgrading or updating PostgreSQL to the latest release.
HOT updates in PostgreSQL for better performance
by
Laurenz Albe |
09.2020UPDATED blog article on 09.01.2023 HOT updates are not a new feature. They were introduced by commit 282d2a03dd in 2007 […]
recovery.conf is gone in PostgreSQL v12
by
Laurenz Albe |
12.2019 The biggest change in PostgreSQL v12 from the viewpoint of backward compatibility is that recovery.conf has been absorbed into […]
PostgreSQL v12 initial query performance impressions
Gauges the query-related performance of PostgreSQL v12. This release add a framework for changing storage engines, & more.
Upgrading Postgres major versions using Logical Replication
This Blog is about PostgreSQL major version upgrade using Logical Replication. Learn about the Benefits of this complex method.
