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 supports a wide variety of indexes. While most of them are common in almost all the databases, there are some types of indexes that are more specific to PostgreSQL.

  • Once we know what type of Indexes are suitable for our requirement, should we create an index physically or can we use a hypothetical index that is imaginary to the Optimizer. If that is possible, are there any extensions that can help us recommend an index than can improve the cost of execution of slow queries automatically ? Let us discuss how it is possible during this talk using one of the logic i have developed for this purpose.

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