Skip to main content
Background Image

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.
The Versatile file_fdw — Reading System Information from Your Database
·846 words·4 mins
With file_fdw, you can easily view operating system information, fetch network data, and feed various data sources into your database for unified viewing and management.