Presented by:

  • Avinash Vallarapu (Avi) is the CEO and Co-founder of MigOps, Inc. Before joining MigOps, Avi worked as a Global Services Lead and Product Owner for PostgreSQL services at Percona, Database Architect at OpenSCG and Dell. Avi has a great expertise on Migrations to PostgreSQL. He has a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB for the last 2 decades. He is an avid Python and Golang developer. He has co-authored multiple books on PostgreSQL : Beginning PostgreSQL on Cloud and PostgreSQL 13 Cookbook.

  • He spoke at various PostgreSQL Conferences in the past including -

    • PGCONF India - 2017/2019
    • PGCON Ottawa 2018
    • Percona Live Frankfurt 2018
    • Postgres Conference New York 2019
    • Percona Live Texas 2019
    • Postgres Open Florida 2019
    • Postgres Conference Silicon Valley 2019
    • Percona Live Amsterdam 2019
    • PGCONF India 2020, New York, Percona Live and some more conferences.
  • His areas of expertise are PostgreSQL Migrations, Training and Consulting.

No video of the event yet, sorry!

  • PostgreSQL implements MVCC in a slightly different way when compared to databases like Oracle, MySQL and others. In PostgreSQL, there is a different method for managing UNDO that requires a cleanup concept called vacuum. Over a period of time, PostgreSQL implemented autovacuum that has been enhanced with every release. It is now important for PostgreSQL admins/DevOPS to understand the internals of autovacuum and the MVCC implementation and avoid how to avoid a transaction wraparound in PostgreSQL.

  • Following topics will be discussed during this talk.

    • 1. MVCC in PostgreSQL.
    • 2. Vacuum and Autovacuum Internals.
    • 3. Parameters to manage and tune autovacuum.
    • 4. Problems in a busy OLTP database with untuned autovacuum settings and the best way of doing it.

Date:
Duration:
50 min
Room:
Conference:
Postgres Conference 2020
Language:
Track:
Ops and Administration
Difficulty:
Easy