Rewrite OR to UNION in PostgreSQL queries
by
Laurenz Albe |
11.2022 In my article that reviles OR, I showed how in certain cases, it is possible to rewrite OR in […]
btree vs. BRIN: 2 options for indexing in PostgreSQL data warehouses
How do you index in a data warehouse? See the advantages and disadvantages of btree (AKA B-tree) and BRIN indexes in PostgreSQL.
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 […]
gexec in psql: PostgreSQL poweruser practice
gexec PostgreSQL poweruser practice: Learn how to use the gexec command and the `||` operator to get the best results out of your psql.
Column order in PostgreSQL does matter
Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables
Case-insensitive pattern matching in PostgreSQL
by
Laurenz Albe |
06.2022 (Updated on 2024-11-27) Case-insensitive search is a much-requested feature, partly (I suspect) to maintain compatibility with Microsoft SQL […]
How to cancel a hanging PostgreSQL query
by
Laurenz Albe |
05.2022 Sometimes a PostgreSQL query takes forever. Usually, it is easy to interrupt (cancel) such a statement, but sometimes it […]
Find and fix a missing PostgreSQL Index
Explains how to find a missing Postgresql index, what you can do to fix missing indexes, and how to achieve good database performance.
Query parameter data types and performance
by
Laurenz Albe |
03.2022 Recently, I could help solve a “mysterious” performance problem for a customer. The problem turned out to be a […]
Pipeline mode for better PostgreSQL performance on slow networks
by
Laurenz Albe |
03.2022 It is known that high network latency is bad for database performance. PostgreSQL v14 has introduced “pipeline mode” for […]
