Checkout the slides

###Introduction The presenter has a unique opportunity to address hundreds of real-world, escalated issues from different users as part of the job. This gave a realisation that many are often running into a group of common mistakes. It will be of great value if PostgreSQL users can understand the mistakes well ahead and avoid them during the system design, development and deployment.

Content includes:

1. Host machine / OS - Problems of poor tuning and remedies
2. Problems during the upgrades and remedies
3. High Availability - Myths and Facts.
4. Synchronous replication - Myths, Facts and Problems people run into.
5. Autovacuum tuning - How things can go really bad.
6. Temporary tables in PostgreSQL - Understand the trap.
7. Network latency - Performance killer, how to check.
8. Indexes - They are not free. It can easily become a big burden unless used judiciously.
9. Most common Parameter tuning mistakes are due to misunderstanding.
10. Performance by design. - PostgreSQL concurrency

scripts/queries which can help users also will be shared.

Summary

This presentation can give an overall idea of common pitfalls. This should enable the audience to raise the Red flags as early as possible and avoid the minefield of common mistakes and associated troubles. This will be “A Practical Guide to Avoiding Disaster”