5.4.4 Performance & tuning
Every entry filed under Performance & tuning and its subtopics.
Level
- Beginner 0
- Intermediate 2
- Advanced 0
Kind
- Tutorial 0
- Concept 1
- How-to 0
- Reference 1
- Fix 0
Platform
Clear filters
- Linux 2 (selected, select to remove)
- macOS 0
- Windows 0
- Browser 0
2 entries match these filters
- 0204 VACUUM, autovacuum and table bloat in PostgreSQL Updates and deletes leave dead row versions behind. VACUUM makes that space reusable, keeps statistics fresh and prevents transaction ID wraparound; autovacuum… Intermediate · Concept · Linux Article Performance & tuning · Roles & administration 15 Oct 2026
- 0207 Find long-running PostgreSQL queries and slow statements A psql-based script that lists sessions whose current query or open transaction is older than a threshold, plus pg_stat_statements queries to find… Intermediate · Reference · Linux Script Performance & tuning · Roles & administration 15 Oct 2026