Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Faster Queries = More Animal Crossing
Search
Jonan Scheffler
March 31, 2020
Programming
0
190
Faster Queries = More Animal Crossing
A quick walkthrough of common query inefficiencies using PostgreSQL and TimescaleDB.
Jonan Scheffler
March 31, 2020
Tweet
Share
More Decks by Jonan Scheffler
See All by Jonan Scheffler
Sleeping in Airports: The Magical, Terrible Life of a Developer Advocate
thejonanshow
0
23
inventing_friends.pdf
thejonanshow
0
22
Inventing Friends: Actioncable + AVS = <3
thejonanshow
0
92
Building HAL: Running Ruby with your Voice
thejonanshow
1
84
Deploying MEAN on Heroku
thejonanshow
2
42
Robolove
thejonanshow
0
79
Hacking Cognition
thejonanshow
2
120
Other Decks in Programming
See All in Programming
talk-with-local-llm-with-web-streams-api
kbaba1001
0
180
Monixと常駐プログラムの勘どころ / Scalaわいわい勉強会 #4
stoneream
0
270
fs2-io を試してたらバグを見つけて直した話
chencmd
0
220
StarlingMonkeyを触ってみた話 - 2024冬
syumai
3
270
フロントエンドのディレクトリ構成どうしてる? Feature-Sliced Design 導入体験談
osakatechlab
8
4.1k
今年一番支援させていただいたのは認証系サービスでした
satoshi256kbyte
1
250
20年もののレガシープロダクトに 0からPHPStanを入れるまで / phpcon2024
hirobe1999
0
170
Full stack testing :: basic to basic
up1
1
930
暇に任せてProxmoxコンソール 作ってみました
karugamo
1
720
採用事例の少ないSvelteを選んだ理由と それを正解にするためにやっていること
oekazuma
2
1k
わたしの星のままで一番星になる ~ 出産を機にSIerからEC事業会社に転職した話 ~
kimura_m_29
0
180
たのしいparse.y
ydah
3
120
Featured
See All Featured
How STYLIGHT went responsive
nonsquared
95
5.2k
A designer walks into a library…
pauljervisheath
204
24k
The Pragmatic Product Professional
lauravandoore
32
6.3k
Typedesign – Prime Four
hannesfritz
40
2.4k
Stop Working from a Prison Cell
hatefulcrawdad
267
20k
Being A Developer After 40
akosma
87
590k
StorybookのUI Testing Handbookを読んだ
zakiyama
27
5.3k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
48
2.2k
Product Roadmaps are Hard
iamctodd
PRO
49
11k
Building Better People: How to give real-time feedback that sticks.
wjessup
365
19k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
eileencodes
17
2.3k
Documentation Writing (for coders)
carmenintech
66
4.5k
Transcript
FASTER QUERIES = MORE ANIMAL CROSSING
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@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
@thejonanshow Thank You! ❤ github.com/timescale/wikistream-docker