PG Admin
PostgreSQL Macro Query Optimization with pg_stat_statements
·4341 words·21 mins
Query optimization is one of the core responsibilities of DBAs. This article introduces how to use metrics provided by pg_stat_statements for macro-level PostgreSQL query optimization.
Testing Disk Performance with FIO
·335 words·2 mins
FIO is a convenient tool for testing disk I/O performance
Finding Unused Indexes
·376 words·2 mins
Indexes are useful, but they’re not free. Unused indexes are a waste. Use these methods to identify unused indexes.