Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Faster Queries = More Animal Crossing

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

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
8
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
0
71
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
1
51
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
8e686c2dcfd4cc143fbc21baf893626b?s=48 tako8ki
1
520
20c5ddcad23304aed77ce8c3aa020562?s=48 tkmru
0
770
06641ec93c5914e0db74cddff2ec6004?s=48 objectiveaudio
0
150
9db605a8fd9732e854a419160821ffeb?s=48 tamacjp
0
200
7a33106dde82ecc65a220eaf9d131222?s=48 patrickjahr
0
150
Eae7b6aeee72d3081b01d09a2d675f9a?s=48 akkeylab
5
990
9bf923e39671cde83584e3e926296c13?s=48 kishikawakatsumi
7
1.4k
Eac0bf787b5279aca5e699ece096956e?s=48 inamiy
7
950
028088964f255d677d471558da865b72?s=48 satoshin
2
150
9bda8755a689204677a198ee85c0eb07?s=48 banjun
PRO
0
130
9bcd328daf60fe29dc9970f6cfc26730?s=48 kesin11
7
1.2k
7850a83d81b034248782d63e7dcf7974?s=48 tatsuya4451
0
490

Featured

See All Featured
Dafc4723e9a1c067796c0fec6f509774?s=48 lemiorhan
633
49k
1519587b1a0febb658c36c94f6272b0d?s=48 roundedbygravity
85
8.1k
1f74b13f1e5c6c69cb5d7fbaabb1e2cb?s=48 sferik
612
56k
C0390e8b11079f8761c0cd3274ed61cb?s=48 productmarketing
11
1.1k
Eb8975af8e49e19e3dd6b6b84a542e26?s=48 qrush
288
19k
C9b18d9dff88a9dd2393364c2b3b21bd?s=48 colly
69
3.2k
5f2da528927a2ec9ba4fec2069cbc958?s=48 kneath
224
15k
96270e4c3e5e9806cf7245475c00b275?s=48 addyosmani
496
110k
3d4519fd34b76fb265fc0237f3792bd4?s=48 danielanewman
208
20k
61857dafbd287b3027c4dcea9008ad3c?s=48 carmenhchung
43
2k
053e75a5b48b44d6dd0612795dfb326d?s=48 notwaldorf
52
3.3k
465724d73fe3a92c0879fdfb43a3a6f3?s=48 philhawksworth
195
9k

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