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 […]
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.
What is fillfactor and how does it affect PostgreSQL performance?
In this blog posting you find out: What is fillfactor and how does it affect PostgreSQL performance? | Effects & Testing
Unearthing some hidden PostgreSQL 11 gems
Kaarel has a look on interesting/useful little features and improvements of PostgreSQL 11. Add column pg_stat_activity.backend_type and more.
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 […]
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 […]
Avoiding “OR” for better query performance
by
Laurenz Albe |
05.2018 PostgreSQL query tuning is our daily bread at CYBERTEC, and once you have done some of that, you'll start […]
Best of PostgreSQL 10 for the Developer
A brief overview of our favourite PostgreSQL 10 features for Developer. Find out more about it - especial for developer.
Best of PostgreSQL 10 for the DBA
PostgreSQL 10 was officially released! In this blog we took you to a tour and made an overview of the best features of PostgreSQL 10.
A quick check on Postgres 10 Beta Analytics Performance vs version 9.6
Is +40% performance improvement real? We did a quick check on PostgreSQL 10 Beta Analytics Performance vs PostgreSQL 9.6.
