PostgreSQL EzzEddin Abdullah in PostgreSQL How to troubleshoot and fix PostgreSQL performance issues PostgreSQL database performance is critical for application performance. EzzEddin Abdullah shows how to get information about a query’s performance from the execution plan.… 25 May 2022 13 min read
Jonathan Lewis Investigating Indexes Rebuilding indexes is an activity that you shouldn’t need to do often. There are always a few special cases – like when you’ve moved or... 28 September 2016 16 min read
Houri Index design: discard and sort Designing an index is not done through “trial and error”. This kind of strategy seems to doom many engineered indexes to imprecision, explosion, and locking... 10 October 2014 17 min read
Kat Hicks Diagnosing Common Database Ails When a database starts showing signs of an illness, it's up to the DBA to get to the root of the problem, fast. Kat Hicks... 25 March 2013 13 min read
Benjamin Nevarez Index Selection and the Query Optimizer While we all know that the Query Optimizer uses Indexes to produce better execution plans, we don't all know exactly which indexes will give the... 25 November 2010 23 min read
Andy Warren Performance tuning tips for database developers Performance tuning is not easy and there aren't any silver bullets, but you can go a surprisingly long way with a few basic guidelines. … 17 May 2005 4 min read
