A quick pg_stat_statements troubleshooting hack
How can pg_stat_statements be used for troubleshooting? Some tips to access all relevant information without using monitoring tools.
effective_cache_size: A practical example
Few people know what effective_cache_size really does in PostgreSQL. Let me share some more insights and a practical example.
Connection of DB2 with PostgreSQL done with the extension db2_fwd | Migration of db2's data to PostgreSQL | Read data from DB2
Composite type performance issues in PostgreSQL
Table functions & performance: Solve performance issues related to stored procedures and or a composite data type in PostgreSQL
Tuning max_connections in PostgreSQL
by
Laurenz Albe |
04.2020 (Updated 2023-02-22) In my daily work, I see many databases with a bad setting for max_connections. There is little […]
Detailed look at the new PostgreSQL troubleshooting extension - pg_show_plans
How to use pg_show_plans to look at execution plans of slow queries in real time as they’re being executed | Troubleshooting tool
Performance differences between normal and generic audit triggers
Performance differences between normal and generic audit triggers | PostgreSQL database | PostgreSQL trigger performance
pg_show_plans: Watching execution plans in PostgreSQL LIVE
pg_show_plans is an extension developed by CYBERTEC, which shows all active query plans in PostgreSQL | Execution plan live in PostgreSQL
CLUSTER: Improving PostgreSQL performance
Learn an important trick to lower the performance impact of data storage methods in your PostgreSQL database. Use CLUSTER to improve speed.
Reduce WAL by increasing checkpoint distance
Adjusting checkpoints is useful when tuning a server and improves the database performance. Furthermore, it helps to reduce WAL.
