PostgreSQL Monitoring
Presented by:
Kevin Kempter
Kevin Kempter is the Founder and Chief Data Architect for Consistent State. Kevin has been in the I.T. field since 1990. Kevin started his career as a Unix/C developer, then moved into embedded SQL development and ultimately into database administration and architecture. Kevin has worked with PostgreSQL for more than 12 years and has filled a variety of roles in various database niches such as : - DBA - Data Warehouse Architect - Database Architect - Database Technical Lead
Today Kevin fills both technical and lead roles within Consistent State. Consistent State is a "PostgreSQL Professional Services Company", offering Advanced Training, Managed Services and Consulting.
No video of the event yet, sorry!
A walk through of monitoring PostgreSQL database clusters to include: Relevant PostgreSQL system catalog metrics Relevant contribs / extensions PostgreSQL log parsers PostgreSQL performance troubleshooting Performance tuning methods We'll discuss important segments to monitor such as: - buffer pool usage and sizing - checkpoints & the bgwriter - table stats such as sequential scans, and hit ratios - vacuum monitoring & tuning - etc
- Date:
- Duration:
- 30 min
- Room:
- Conference:
- PGConf US 2016 [PgConf.US]
- Language:
- Track:
- Operations
- Difficulty:
- Medium