Deduplication in PostgreSQL v13 B-tree indexes
by
Laurenz Albe |
06.2020 A while ago, I wrote about B-tree improvements in v12. PostgreSQL v13, which will come out later this year, […]
B-tree index improvements in PostgreSQL v12
by
Laurenz Albe |
11.2019 If you thought that the B-tree index is a technology that was perfected in the 1980s, you are mostly […]
Composite/ combined indexes vs. separate indexes in PostgreSQL
What is more beneficial: Using separate or combined indexes in your PostgreSQL database? Speed performance by understanding index scans.
Since I only recently learned about the concept of “killed index tuples”, I thought there might be some others […]
Foreign Key Indexing and Performance in PostgreSQL
by
Laurenz Albe |
10.2018Foreign key constraints are an important tool to keep your database consistent while also documenting relationships between tables. A fact […]
Correlation of PostgreSQL columns explained
by
Laurenz Albe |
09.2018After you ANALYZE a PostgreSQL table to collect value distribution statistics, you will find the gathered statistics for each column […]
PostgreSQL: Parallel CREATE INDEX for better performance
How to use parallel CREATE INDEX in PostgreSQL, which will eliminate various performance bottlenecks - especially for large applications.
Adding an index can decrease SELECT performance
by
Laurenz Albe |
06.2018 We all know that you have to pay a price for a new index you create — data modifying […]
Why should I get rid of unused indexes? Everybody knows that a database index is a good thing because it […]
PostgreSQL indexing: Index scan vs. Bitmap scan vs. Sequential scan (basics)
Introduction to PostgreSQL indexing. How and when to use an index scan, bitmap scan and/or sequential scan. Get performance tips.
