Скачать или смотреть Lesson #11 - Index Only Scans - Deep Dive Into PostgreSQL Indexes Course

We present the Deep Dive Into #PostgreSQL Indexes course.

In this lesson, Ibrar will talk about How are tables indexes scanned, when both are scanned and when only the index?

The course consists of 13 short videos where Ibrar Ahmed explains PostgreSQL Indexes.


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.
Take the full course and pass the quiz in our Google class to get a certificate.
https://classroom.google.com/c/MTQ4Mz...


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.
Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔
📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about PostgreSQL Databases, and many other things.
https://percona.tv/subscribe


Armed with more advanced knowledge, you can avoid this worst-case scenario! 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.


Just open Google Classroom and click "Join class", enter the code of the class "xk5k6fz".
You'll need a gmail.com account.

Continue watching the 12th part of the course ⏩    • Lesson #12 - How to Find Duplicate Indexes...  

📺Watch the full course in this playlist 📝 ⏩ https://percona.tv/mysqlupdate


You can find more information about #PostgreSQL #Databases and Percona Database Events in these links 👇🏻👇🏻👇🏻

Postgresql Support ⏩ https://per.co.na/postgresql-support
Postgresql info ⏩ https://per.co.na/postgresql-info
Postgresql events ⏩ https://per.co.na/lGkGc9
Percona Private Cloud ⏩ https://per.co.na/pl2020
Percona Distribution for PostgreSQL ⏩ https://per.co.na/postgresql
Monitor your PostgreSQL Free ⏩ https://percona.tv/pmm-yt

Don't miss out Percona Live Online 2020 For Free — register today! ⏩ https://hubs.ly/H0wXdB-0


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


What are you doing here 🤔 ? Likes 👍 are on 🔝