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
pg_show_plans: Watching execution plans in PostgreSQL LIVE
pg_show_plans is an extension developed by CYBERTEC, which shows all active query plans in PostgreSQL | Execution plan live in PostgreSQL
Prewarming PostgreSQL I/O caches
How to deal with PostgreSQL restarts? pg_prewarm allows you to automatically prewarm your caches after a database failure or a simple restart
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 the Developer. Find out more about it - especial for developers.
