Kevin Kempter

Chief Data Architect at Consistent State

About

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.

Kevin Kempter has presented the following presentations

    Kevin Kempter Enterprise Data Architecture with PostgreSQL at PGConf Local: Seattle [PgConf.US]

    presented by Kevin Kempter

    We'll discuss architecture and scaling to include:

    • monitoring & "Monthly DB Reports"
    • backup / recovery
    • replication & HA
    • DR sites and connection pooling
    • Capacity planning & metrics
    • Scaling
    • Ongoing Architecture Monitoring & Lifecycle

    Tue 14 2017 ops
    Kevin Kempter Enterprise Data Architecture with PostgreSQL at PGConf US 2017 [PgConf.US]

    presented by Kevin Kempter


    video

    This presentation will address Enterprise Data Architecture methods and components with PostgreSQL based on our experience in the trenches. Topics include:

    Monitoring automation

    • Backup & recovery automation

    • The DB assessment

    • Defining capacity and scaling points

    • Scaling options

    • The Data Architecture Lifecycle

    Operations
    Kevin Kempter PostgreSQL Monitoring at PGConf US 2016 [PgConf.US]

    presented by Kevin Kempter

    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...

    more

    Operations