Pro Yearly is on sale from $80 to $50! »

Faster Queries = More Animal Crossing

7353db17cf19f920fbd24479c8157781?s=47 Jonan Scheffler
March 31, 2020
Programming
0
61

Faster Queries = More Animal Crossing

A quick walkthrough of common query inefficiencies using PostgreSQL and TimescaleDB.

7353db17cf19f920fbd24479c8157781?s=128

Jonan Scheffler

March 31, 2020
Tweet

More Decks by Jonan Scheffler

See All by Jonan Scheffler
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
0
5
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
0
6
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
0
64
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
1
49
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
2
35
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
0
29
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
2
99

Other Decks in Programming

See All in Programming
Acdecb7b4baebb0d4c521626d21adc6a?s=48 motikoma
1
260
F52f4adb291c5b44bd8ad1433dfedaaf?s=48 ytyubox
1
470
1fab9d01b25e99522f3dfd01e3d4cb51?s=48 soutaro
0
450
3f2e97dc4e6a5daaf1cb8a406c533176?s=48 knqyf263
3
660
7f68f5f85f4a39df7d8d3c81cbbfb788?s=48 p1ass
0
130
354e3e2cfb772abdf62bd92c92f89547?s=48 tarunpothulapati
0
130
7c9b8b368924556d8642bdaed3ded1f5?s=48 danilop
1
240
85977ebfe59c2ee669f2196930f1a701?s=48 mehowte
0
140
1dfa2bb34977b1db41d0d46d4505183f?s=48 osuke
2
320
1405a601755e5fcbfdc93a2560368bb1?s=48 freddi
0
220
42a6a049ac8f5265f31858a9509217fb?s=48 uhooi
0
250
Eb44761e0fb3a5ec8e23ec28048dd7a5?s=48 stoitsev
1
120

Featured

See All Featured
0fe2973fa8d27d96547e43322341183a?s=48 swwweet
206
6.8k
3d4519fd34b76fb265fc0237f3792bd4?s=48 danielanewman
199
19k
027d1ebf66cc039a0bd3b55eeadbe75d?s=48 sachag
447
36k
3ab1249be442027903e1180025340b3f?s=48 reverentgeek
168
7k
24fc194843a71f10949be18d5a692682?s=48 gr2m
82
11k
Ded01cdab114abe4ec13511e4c25b9bb?s=48 andyhume
61
2.5k
E76911cbe088e5b850d966de3fc7435b?s=48 robhawkes
52
2.7k
78b475797a14c84799063c7cd073962f?s=48 holman
448
130k
766b9746b59e6f09e280cd33cf4ed419?s=48 skipperchong
6
600
4394ceb8b277f35ee3da7030384efb5d?s=48 davidbonilla
69
3.5k
61857dafbd287b3027c4dcea9008ad3c?s=48 carmenhchung
22
1.2k
282d599b414022eba5096510f675b6e2?s=48 chrislema
231
16k

Transcript

  1. FASTER QUERIES = MORE ANIMAL CROSSING

  2. @thejonanshow

  3. @thejonanshow

  4. @thejonanshow

  5. @thejonanshow

  6. @thejonanshow

  7. @thejonanshow

  8. @thejonanshow

  9. @thejonanshow

  10. @thejonanshow

  11. @thejonanshow

  12. @thejonanshow

  13. @thejonanshow

  14. @thejonanshow

  15. @thejonanshow

  16. @thejonanshow

  17. @thejonanshow

  18. @thejonanshow

  19. @thejonanshow

  20. @thejonanshow

  21. @thejonanshow

  22. @thejonanshow

  23. @thejonanshow

  24. @thejonanshow

  25. @thejonanshow

  26. @thejonanshow

  27. @thejonanshow

  28. @thejonanshow

  29. @thejonanshow

  30. @thejonanshow

  31. @thejonanshow

  32. @thejonanshow

  33. @thejonanshow

  34. @thejonanshow - Common Table Expressions slow down small queries

  35. @thejonanshow - Common Table Expressions slow down small queries -

    LIKE and ILIKE dodge indexes, use pg_trgm

  36. @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

  37. @thejonanshow Thank You! ❤ github.com/timescale/wikistream-docker