Presented by:

Photo

Mahadevan Ramachandran

RapidLoop, Inc.

Mahadevan RAMACHANDRAN is the co-founder and CEO of RapidLoop, Inc. He drives the development of RapidLoop’s monitoring solutions, including pgDash and is the author of popular open source tools including pgmetrics, an open source PostgreSQL metrics collection tool. Mahadevan has nearly 25 years of experience in the software industry. He has served as game CTO for top Zynga titles reaching millions of players and led development teams at Siemens, Philips, Emulex and EMC.

https://www.rapidloop.com/#aboutus

No video of the event yet, sorry!

The PostgreSQL server consists of several complex subsystems, each of which need to be monitored and tuned to maintain optimal health and performance. This presentation walks you through the monitoring of all important aspects of your PostgreSQL deployment, highlighting what to monitor, how to monitor and why to monitor each of them:

  • backend activity
  • wal files: archiving, growth
  • vacuum progress and impact
  • tablespaces and disk usage
  • indexes: efficiency, size, bloat
  • tables: growth, modifications
  • logical and streaming replication
  • locks and blocked queries
  • background writer

The usage of the open source tool pgmetrics to aid this effort is demonstrated.

Date:
Duration:
20 min
Room:
Conference:
Postgres Conference 2020
Language:
Track:
Ops and Administration
Difficulty:
Medium