Presented by:

B3e314bbf4bec1eeca20175ca8018a56

Avinash Vallarapu

from Percona
  • Avinash Vallarapu (Avi) is currently working for Percona as a PostgreSQL Support Tech Lead. Before joining Percona, he worked for OpenSCG for 2.2 years as a Database Architect and for Dell as a Tech Lead for 9.8 Years. He has a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB. He is an avid Python and Golang developer. He has co-authored a book on PostgreSQL : Beginning PostgreSQL on Cloud and another book on MySQL is in progress.

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

    • PGCONF India - 2017 - Bengaluru, India.
    • PGCON 2018 - Ottawa, Canada.
    • Percona Live - PostgreSQL Track (2018) - Frankfurt, Germany.
  • His areas of expertise are PostgreSQL Training, Consulting and Migrations.

No video of the event yet, sorry!

Download slides

** Title : A detailed understanding of MVCC and autovacuum internals in PostgreSQL. **

  • *Abstract : *

    • PostgreSQL implements MVCC in a slightly different way when compared to databases like Oracle, MySQL and others. In PostgreSQL, you see a different method for managing UNDO which 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. We shall discuss these topics in detail during this talk.
  • *This talk includes - *

    • 1. MVCC in PostgreSQL.
    • 2. Vacuum and Autovacuum Internals.
    • 3. Parameters you should know to understand how autovacuum works.
    • 4. Problems you may see in a busy OLTP database with untuned autovacuum settings.
    • 5. Methods to tune the autovacuum parameters in PostgreSQL.

Date:
2019 February 15 - 11:15
Duration:
45 min
Room:
Ballroom 1
Conference:
PGConf India, 2019
Language:
Track:
Database Engine Developer
Difficulty:
Intermediate

Happening at the same time:

  1. Partitioning & Time Series
  2. Start Time:
    2019 February 15 11:15

    Room:
    Ballroom 4

  3. Parallel Query in PostgreSQL: How not to (mis)use it?
  4. Start Time:
    2019 February 15 11:15

    Room:
    Ballroom 3