Kevin Kempter
Chief Data Architect at 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.
Upcoming presentations
No upcoming presentations...
Past presentations
- monitoring & "Monthly DB Reports"
- backup / recovery
- replication & HA
- DR sites and connection pooling
- Capacity planning & metrics
- Scaling
- Ongoing Architecture Monitoring & Lifecycle
Backup & recovery automation
The DB assessment
Defining capacity and scaling points
Scaling options
The Data Architecture Lifecycle
We'll discuss architecture and scaling to include:
Nov 14 2017
This presentation will address Enterprise Data Architecture methods and components with PostgreSQL based on our experience in the trenches. Topics include:
Monitoring automation
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 rat...