On-Demand Webinar


Deep Dive into PostgreSQL Indexing

 

 

Indexes are a fundamental feature of relational databases and PostgreSQL offers developers and designers a rich collection of options. But not all indexes are appropriate for all circumstances. Using a ‘wrong’ index can have the opposite effect to what you intend, and problems might only surface once in production. 

Armed with more advanced knowledge, you can avoid this worst-case scenario! 

Join Ibrar Ahmed, Senior Software Architect at Percona for this technical session as he takes a deep dive into indexing to show you: 

  • How to compare index types and apply them to different application scenarios
  • How to use pg_stat_statement to find opportunities for adding indexes to your database 
  • Best practices for database index strategy and design

 

Fill out the form below to watch this webinar on-demand.

ibrar-ahmed-circle

Ibrar Ahmed, Senior Software Architect

Ibrar Ahmed is a Senior Software Architect in Percona LLC. Before coming to open source development, he had vast experience in software design and development. His primary focus was on system-level embedded development. After joining EnterpriseDB in 2006, an Enterprise PostgreSQL company, he started his career in open source development, specifically in PostgreSQL. He has contributed to the PostgreSQL community as well as other open source communities. His contribution ranges from the main performance feature enhancements to various PostgreSQL modules. In the database field, he has experience in other well-known databases MySQL, Oracle, and NoSQL databases such as MongoDB and Hadoop. His expertise is not limited to core databases but with the tools related to databases like Hive, HBase, and Spark. He also worked on integrating these tools with PostgreSQL.

 

Hear What Our Customers Have to Say

“Percona’s technical support is very efficient and helpful, ensuring that reported issues are swiftly resolved. Percona have provided us with the best solutions and identified opportunities for improvement in many areas of MySQL, Postgres, and MongoDB.”