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

Faster Queries = More Animal Crossing

Jonan Scheffler
March 31, 2020
Programming
0
100

Faster Queries = More Animal Crossing

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

Jonan Scheffler

March 31, 2020
Tweet

More Decks by Jonan Scheffler

See All by Jonan Scheffler
Sleeping in Airports: The Magical, Terrible Life of a Developer Advocate
thejonanshow
0
13
inventing_friends.pdf
thejonanshow
0
20
Inventing Friends: Actioncable + AVS = <3
thejonanshow
0
82
Building HAL: Running Ruby with your Voice
thejonanshow
1
60
Deploying MEAN on Heroku
thejonanshow
2
38
Robolove
thejonanshow
0
48
Hacking Cognition
thejonanshow
2
110

Other Decks in Programming

See All in Programming
EbitengineでGUIツール作ってみた
aethiopicuschan
0
270
第6回 AWSとGitHub勉強会 - AWS ECS Fargate環境の構築 -
ogiwarat
0
140
第1回 AWSとGitHub勉強会 - キックオフ -
ogiwarat
0
140
ZennにみるCloudRunとBigQueryによるアプリケーション構築 / zenn-cloudrun-bigquery-serverless
wadayusuke
13
3.5k
Reimagining text fields in Compose (dcNYC 23)
zachklipp
0
220
Compose 첫 걸음 || Compose Migration
juhyung
2
100
Migrating From Spring Boot 2 To Spring Boot 3 - What's Jakarta EE Got To Do with It?
ivargrimstad
0
500
Android MVVM 패턴의 접근법 - 2023 드로이드 나이츠
taehwandev
1
610
[2023/09/15]ER図クエスト 過ぎ去りしドキュメントを求めて 〜複雑性に眠る秘宝〜
tosite
0
110
A JVM Threading Model for the containerized times
lhespanha
0
960
Twillio SDKをFlutterアプリに統合した話/twilio-in-flutter
minma_curama
0
120
外部APIとズブズブな開発どうしてますか？
kin29
1
330

Featured

See All Featured
The Illustrated Children's Guide to Kubernetes
chrisshort
26
45k
The Art of Programming - Codeland 2020
erikaheidi
39
12k
Rails Girls Zürich Keynote
gr2m
90
12k
Robots, Beer and Maslow
schacon
154
7.6k
Code Review Best Practice
trishagee
53
13k
Designing the Hi-DPI Web
ddemaree
274
33k
From Idea to $5000 a Month in 5 Months
shpigford
376
45k
Product Roadmaps are Hard
iamctodd
42
8.7k
Designing Experiences People Love
moore
133
22k
Fireside Chat
paigeccino
18
2.2k
Bash Introduction
62gerente
603
210k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
226
16k

Transcript

  1. FASTER QUERIES
    = MORE ANIMAL CROSSING

    View Slide

  2. @thejonanshow

    View Slide

  3. @thejonanshow

    View Slide

  4. @thejonanshow

    View Slide

  5. @thejonanshow

    View Slide

  6. @thejonanshow

    View Slide

  7. @thejonanshow

    View Slide

  8. @thejonanshow

    View Slide

  9. @thejonanshow

    View Slide

  10. @thejonanshow

    View Slide

  11. @thejonanshow

    View Slide

  12. @thejonanshow

    View Slide

  13. @thejonanshow

    View Slide

  14. @thejonanshow

    View Slide

  15. @thejonanshow

    View Slide

  16. @thejonanshow

    View Slide

  17. @thejonanshow

    View Slide

  18. @thejonanshow

    View Slide

  19. @thejonanshow

    View Slide

  20. @thejonanshow

    View Slide

  21. @thejonanshow

    View Slide

  22. @thejonanshow

    View Slide

  23. @thejonanshow

    View Slide

  24. @thejonanshow

    View Slide

  25. @thejonanshow

    View Slide

  26. @thejonanshow

    View Slide

  27. @thejonanshow

    View Slide

  28. @thejonanshow

    View Slide

  29. @thejonanshow

    View Slide

  30. @thejonanshow

    View Slide

  31. @thejonanshow

    View Slide

  32. @thejonanshow

    View Slide

  33. @thejonanshow

    View Slide

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

    View Slide

  35. @thejonanshow
    - Common Table Expressions slow down small queries
    - LIKE and ILIKE dodge indexes, use pg_trgm

    View Slide

  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

    View Slide

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

    View Slide