A Deep Dive Into PostgreSQL Indexing - PostgreSQL Index Tutorial скачать в хорошем качестве

A Deep Dive Into PostgreSQL Indexing - PostgreSQL Index Tutorial

Ibrar Ahmed (Percona) delivers the talk, "A Deep Dive Into PostgreSQL Indexing", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX. Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔 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! 📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, and many other things. https://percona.tv/subscribe We'll take a look at 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. Download Percona Distribution for PostgreSQL Free! ⏩https://per.co.na/postgresql You can find more information about #PostgreSQL #Databases and Percona Live Online 2020 in these links 👇🏻👇🏻👇🏻 https://per.co.na/postgresql-support https://per.co.na/postgresql-info https://per.co.na/lGkGc9 https://per.co.na/pl2020 Connect With us on our Social Networks 👇🏻👇🏻👇🏻 Follow Percona on Twitter: https://per.co.na/twitter Follow Percona on Facebook: https://per.co.na/facebook Follow Percona on Instagram: https://per.co.na/instagram Follow Percona on LinkedIn: https://per.co.na/linkedin