PostgreSQL parallel query problems in JDBC and DBeaver
by
Laurenz Albe |
01.2024By default, PostgreSQL does not use parallel query when you use DBeaver. This article describes the cause and how to fix it.
Broken foreign keys: how can that happen in PostgreSQL?
by
Laurenz Albe |
12.2023One of the fundamental requirements for a relational database is that the transaction system always maintains consistency. That means that […]
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 […]
(Updated 2024-12-23) Among the many index types in PostgreSQL, the hash index is the most widely ignored. This came home […]
Conditional foreign keys and polymorphism in SQL: 4 Methods
by
Laurenz Albe |
08.2023© 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 […]
Indexing "LIKE" in PostgreSQL and Oracle
by
Laurenz Albe |
08.2023© 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 […]
Bulk load performance in PostgreSQL
by
Laurenz Albe |
08.2023 There are several techniques to bulk load data into PostgreSQL. I decided to compare their performance in a simple […]
Subqueries and performance in PostgreSQL
by
Laurenz Albe |
07.2023 SQL allows you to use subqueries almost anywhere where you could have a table or column name. All you […]