Presented by:

Kevin Kempter

Consistent State

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