A quick walkthrough of common query inefficiencies using PostgreSQL and TimescaleDB.
FASTER QUERIES= MORE ANIMAL CROSSING
View Slide
@thejonanshow
@thejonanshow- Common Table Expressions slow down small queries
@thejonanshow- Common Table Expressions slow down small queries- LIKE and ILIKE dodge indexes, use pg_trgm
@thejonanshow- Common Table Expressions slow down small queries- LIKE and ILIKE dodge indexes, use pg_trgm- Types matter, avoid letting the planner cast values for you
@thejonanshowThank You!❤github.com/timescale/wikistream-docker