When an index does more harm than good: cleaning PostgreSQL waste
PostgreSQL: how to find and drop unused indexes with pg_stat_user_indexes. Real case: a table with 15 indexes, 8 of them never used.
Tuning
6 tagged articles
PostgreSQL
PostgreSQL
pg_stat_statements: the first thing to install on any PostgreSQL
PostgreSQL pg_stat_statements: the first query diagnostics extension to install. Find the three queries consuming 80% of database resources.
PostgreSQL
VACUUM and autovacuum: why PostgreSQL needs someone to clean up
PostgreSQL VACUUM and autovacuum: bloat diagnosis on a 200 GB database, reading pg_stat_user_tables and tuning without disabling anything.
Oracle
Oracle on Linux: the kernel parameters nobody configures
Oracle 19c on Linux: kernel tuning for real performance. Huge Pages, THP, swappiness, I/O scheduler, ulimit — before and after numbers.
Oracle
AWR, ASH and the 10 minutes that saved a go-live
Oracle 19c performance tuning with AWR and ASH: finding a hidden full table scan in a stored procedure in 10 minutes, the eve of a go-live.
Oracle
Oracle Partitioning: when 2 billion rows no longer fit in a query
Oracle Partitioning on a 2-billion-row table: range, interval, partition pruning, local indexes. From hours to seconds on reporting queries.