How to implement community open source PostgreSQL to do a fuzzy search & get better results. Find out how to use the fuzzystrmatch extension.
How to use data locality to increase performance while sharding PostgreSQL data with Citus. What is database locality
How to monitor replication lag in PostgreSQL? What is replication lag? And how to best go about monitoring PostgreSQL replication in general?
Here’s how to shard a table from scratch with Citus. Scale PostgreSQL DBs using a sharding approach. How to run a Citus Docker container.
Exclusion constraints in PostgreSQL are complex, see this use case using WHERE STATUS. There are limits to what exclusion constraints can do.
This article is about the notoriously difficult problem of “conditional foreign keys”. In object-oriented programming languages, polymorphism is a […]
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 […]
