Mostly mistaken and ignored PostgreSQL parameters while optimizing a PostgreSQL database
Presented by:
Avinash Vallarapu
Avinash Vallarapu (Avi) is the CEO and Founder of HexaCluster, a company specialized in Database Migrations, PostgreSQL Consulting, Application Migrations and Modernizations, and AI/ML Services. Before creating HexaCluster, Avi was the CEO and Co-founder of MigOps, specialized in database migrations to PostgreSQL. He created the PostgreSQL practice at Percona as a Global Services Lead and Product Owner, and worked as a Database Architect at OpenSCG and Dell. With a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB for the last 2 decades, Avi had 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
- PGCON Ottawa
- Percona Live Frankfurt
- Postgres Conference New York
- Percona Live Texas
- Postgres Open Florida
- Postgres Conference Silicon Valley
- Percona Live
- GITEX Global
- and some more conferences.
His areas of expertise are PostgreSQL Migrations, Training and Consulting.
No video of the event yet, sorry!
*Abstract : *
- Optimizing a PostgreSQL database may be a challenge if some of the important parameters are ignored. And a bigger challenge may be the algorithm behind setting those parameters correctly. In my experience with PostgreSQL Consulting for more than a decade, I have seen a bigger list of parameters that are wrongly set or ignored. This talk details a list of important PostgreSQL parameters with some good description, that could drastically improve the performance graph when properly set. We shall also discuss some mathematical formulae and some extensions helpful to expose the diagnostic data for tuning these parameters. This talk should help both the beginners and also PostgreSQL admins to go back and check if they have tuned these parameters correctly in their PostgreSQL environments.
- Date:
- 2019 September 20 14:00 PDT
- Duration:
- 50 min
- Room:
- Winchester (1)
- Conference:
- Silicon Valley 2019
- Language:
- Track:
- Ops and Administration
- Difficulty:
- Easy