DjangoCon 2019 - Postgres Index types and where to find them by Louise Grandjonc

Channel:
United States Confreaks
Subscribers:
42,400
Published on ● Video Link: https://www.youtube.com/watch?v=iS0FRHOlD34


Duration: 29:20
52 views
3

DjangoCon 2019 - Postgres Index types and where to find them by Louise Grandjonc

For a long time I only used the default btree to index data. As I was working on an app for crocodiles to find their dentist, I started looking into the other index types postgres offers to improve SQL performance. If you want to know all about btree, gin, gist… how, when and why use them, join me!

This talk was presented at: https://2019.djangocon.us/talks/postg...

LINKS:
Follow Louise Grandjonc πŸ‘‡
On Twitter: https://twitter.com/louisemeta
On GitHub: https://github.com/louiseGrandjonc
Official homepage: http://louisemeta.com

Follow DjangCon US πŸ‘‡
https://twitter.com/djangocon

Follow DEFNA πŸ‘‡
https://twitter.com/defnado
https://www.defna.org/

Intro music: "This Is How We Quirk It" by Avocado Junkie.
Video production by Confreaks TV.
Captions by White Coat Captioning.



Other Videos By Confreaks


2022-08-23GRCon19 - Man or Machine?: Developing a "Turing Test" for Radio Intelligence by Adam Anderson
2022-08-23GRCon19 -Striving for SDR Performance Portability in the Era of Heterogeneous SoCs by Jeffrey Vetter
2022-08-23GRCon19 - UHD Four-O by Martin Braun
2022-08-23GRCon19 - Mega Hertz, Mega Samples, Mega bits, Mega Confusing by Robin Getz
2022-08-23GRCon19 - Concerning Radio Hardware and Studebaker Repair by Travis Goodspeed
2022-08-23GRCon19 - GNU Radio Project Update by Ben Hilburn
2022-08-23GRCon19 - Huntsville's Connection to Space by Mike Ward
2022-08-21DjangoCon 2019 - Goodbye Print, Hello Debugger! by Nina Zakharenko
2022-08-21DjangoCon 2019 - Pull Requests: Merging good practices into your project by Luca Bezerra
2022-08-21DjangoCon 2019 - Building a multi factor SSO for a whole country with Django by Juan Saavedra
2022-08-21DjangoCon 2019 - Postgres Index types and where to find them by Louise Grandjonc
2022-08-21DjangoCon 2019 - Creating a containerized Django + React + PostgreSQL... by Dan Taylor
2022-08-21DjangoCon 2019 - The blameless post mortem: how embracing failure makes us better by Chris Wilcox
2022-08-21DjangoCon 2019 - Prefetching for Fun and Profit by Mike Hansen
2022-08-20DjangoCon 2019 - Django REST Framework: Taking your API to the next level by Carlos Martinez
2022-08-20DjangoCon 2019 - How to Hack (Legally): Python Edition by Karen Miller
2022-08-20DjangoCon 2019 - Lazy Looping: The Next Iteration by Trey Hunner
2022-08-20DjangoCon 2019 - Technical Debt: Why it'll ruin your software by Luan Fonseca
2022-08-20DjangoCon 2019 - Lightning Talks Day 2 by Kojo Idrissa
2022-08-20DjangoCon 2019 - Static Typing in Python by Dustin Ingram
2022-08-20DjangoCon 2019 - Migrating legacy data to your Django project by Adolfo Fitoria