PostgreSQL Performance and Maintenance

From East 2010 Speakers

The class is designed to get you a complete overview of production performance and maintenance requirements for PostgreSQL. We will be discussing performance and maintenance together because they are dependent on each other. In order to achieve proper performance of your PostgreSQL cluster, you must maintain it.

Topics covered are:

  • RAID
  • DAS/SAN/NAS
  • CPU
  • OS Optimization (Linux)
  • Proper partitioning
  • PostgreSQL Memory tuning including shared_buffers, working memory, maintenance memory
  • I/O Optimization including Bgwriter, WAL
  • Autovacuum
  • Other maintenance tasks (REINDEX, CLUSTER etc..)

    Trainer: Joshua D. Drake