Presented by:

03b4aebea11b0da7edc715cb07c0e35e
Nikolay Samokhvalov
from Postgres.ai

More than 17 years of experience with various DBMSes, more than 13 years with PostgreSQL. M.S., MIPT and ISP RAS, specialty "Database systems".

Founder of Postgres.ai (data-driven Postgres management, artificial DBAs, automation of DBA tasks. We do deep health checks of large DBs during just 4 hours instead of 2 weeks).

Founder of #RuPostgres (PostgreSQL user group for Russian-speaking users, 2nd on Meetup.com, 2000+ members).

Committee Chair of program committees of various conferences: PGIBZ, Highload++, RIT/BackendConf, PgDay.ru.

Russian press contact at PostgreSQL Global Development Group.

Twitter: @postgresmen

No video of the event yet, sorry!

Full-fledged health check of heavily loaded multi-terabyte production database usually takes many days of expert work. With postgres-checkup, it takes just a few hours.


postgres-checkup is a new approach to survive in the era of clouds, microservices, and rapid transformation of DBA profession. Among its key features are:

  • ☞ close-to-zero footprint (risks of the "observer effect" are mitigated);

  • ☞ "zero install": nothing needs to be installed on Postgres servers;

  • ☞ reporting formats are both human- and machine-friendly (JSON, markdown, HTML, PDF).


We will discuss how you can quickly perform health check without deep internals knowledge, diving into the following topics:

  • ☞ autovacuum & bloat;

  • ☞ indexes health;

  • ☞ deep query analysis.


Date:
2019 June 21 - 11:30
Duration:
50 min
Room:
C2
Conference:
PostgreSQL Ibiza
Language:
English
Track:
Track 2
Difficulty:
Medium

Happening at the same time:

  1. Living in GDPR world
  2. Start Time:
    2019 June 21 11:30

    Room:
    C1