Categories
Databases

PostgreSQL B*-tree index benchmark

I’ve recently started fiddling with PostgreSQL performance optimization. Here is a little benchmark that I’ve compiled in order to investigate impact of Postgres indexes usage on query execution times and disk usage.