But there is still no better resource for technical details in Postgres than this series https://habr.com/en/company/postgrespro/blog/441962/
Re:Postgres Indexes for Newbies
by tomnipotent on Thursday January 20, 2022 @05:12PM
(#30015904)
These are great, thank you.
https://www.youtube.com/playlist?list=PLSE8ODhjZXjbohkNBWQs_... (Pavlo, 2019)
https://www.youtube.com/playlist?list=PLSE8ODhjZXjZaHA6QcxDf... (Crotty, 2021)