A Deep Dive into PostgreSQL Indexing
Presented by:
Ibrar Ahmed
Ibrar Ahmed is a seasoned Principal Engineer at pgEdge, bringing a wealth of experience in software design and development to the world of open source. With a strong background in system-level embedded development, Ibrar has honed his expertise over the years with renowned PostgreSQL companies such as EnterpriseDB, Percona, and Bitnine.
Having embarked on his journey with PostgreSQL since 2006, Ibrar has become intricately involved in the core engine of PostgreSQL, making significant contributions to its evolution. From spearheading major performance enhancements to refining various PostgreSQL modules, his dedication to advancing the platform has left an indelible mark on the PostgreSQL community.
Beyond PostgreSQL, Ibrar's proficiency extends to a multitude of databases, including MySQL, Oracle, and cutting-edge NoSQL technologies like MongoDB and Hadoop. His expertise isn't confined solely to databases; he possesses adeptness with related tools such as Hive, HBase, and Spark, seamlessly integrating them with PostgreSQL to unlock new possibilities in data management and analytics.
Recognized for his depth of knowledge and insight, Ibrar has authored multiple authoritative books on PostgreSQL and is a highly regarded blogger within the PostgreSQL community, sharing valuable insights and best practices with a global audience. With a passion for innovation and a commitment to excellence, Ibrar Ahmed continues to drive forward the boundaries of database technology, shaping the future of data management in the digital age. He gave more than fifteen PostgreSQL talks in the last one year in various parts of the World (PostgreConf-EU, PostgreConf-ASIA, PostgreConf-NY, Percona Lives, etc ). He also authored multiple books on PostgreSQL.
No video of the event yet, sorry!
Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index types and how they apply to different application scenarios. Only then can you make an informed decision about your database index strategy and design. One thing is for sure: not all indexes are appropriate for all circumstances, and using a ‘wrong’ index can have the opposite effect to that you intend and problems might only surface once in production. Armed with more advanced knowledge, you can avoid this worst case scenario! We’ll take a look on how to use pg_stat_statment to find opportunities for adding indexes to your database. We’ll take a look at when to add an index, and when adding an index is unlikely to result in a good solution. So should you add an index to every column? Come and discover why this strategy is rarely recommended as we take a deep dive into PostgreSQL indexing.
- Date:
- 2019 July 5 10:50 CST
- Duration:
- 40 min
- Room:
- JINGGE HALL TRACK1 - English Track
- Conference:
- Beijing 2019
- Language:
- Track:
- English Speaker Track
- Difficulty:
- Easy