© Laurenz Albe 2023 This article is about the notoriously difficult problem of “conditional foreign keys”. In object-oriented programming languages, […]
PostgreSQL v16 contains many new features and enhancements. Here are PG v16's 14 best new features: Everybody's favorite: You no longer […]
© Laurenz Albe 2023 Unless you use the binary collation, creating a b-tree index to support a LIKE condition in […]
"Why does my pg_wal keep growing?" That's a question I keep hearing again and again. It is an urgent […]
There are several techniques to bulk load data into PostgreSQL. I decided to compare their performance in a simple […]
Partitioning is not without risk. It might help to handle large quantities of data, but it can also have downsides - learn how to it.
This post shows how to optimize a slow query that came out of the Reproducible Builds project. The Reproducible Builds […]
How to analyze a stretch of the Tour de France in a hybrid environment, ArcGIS Enterprise & PostGIS - we’ll utilize PostGIS native geometry types instead of ESRI geometry types to analyze this challenging stage both in ArcGIS Pro and PostGIS
SQL allows you to use subqueries almost anywhere where you could have a table or column name. All you […]
How to fix the view access logging in an established database. Find out how Kirk Wolak renamed and tracked all the views in his Postgres DB.
(updated 2025-01-27) PostgreSQL uses shared memory for data shared between processes. With the exception of the dynamic shared memory […]
There are various compelling reasons to use universally unique identifiers (UUID) as primary keys. Two examples are: To be able […]
