CREATE INDEX: Data types matter
Data types play a crucial role in ensuring optimal performance, efficiency, as well as semantics. Read more about CREATE INDEX.
Speeding up index creation in PostgreSQL
In this blog we are talking about indexes. Speeding up index creation in PostgreSQL is one of the main topic.
(Updated 2024-12-23) Among the many index types in PostgreSQL, the hash index is the most widely ignored. This came home […]
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 […]
Unexpected downsides of UUID keys in PostgreSQL
There are various compelling reasons to use universally unique identifiers (UUID) as primary keys. Two examples are: To be able […]
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.
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.
Most database tables have an artificial numeric primary key, and that number is usually generated automatically using a sequence. […]
PostgreSQL: Create indexes after bulk loading
This post describes when to create indexes, before or after bulk loading of the data. Improve your PostgreSQL performance by doing it right.
Index bloat reduced in PostgreSQL v14
by
Laurenz Albe |
09.2021 PostgreSQL v12 brought more efficient storage for indexes, and v13 improved that even more by adding deduplication of index […]
