Faster Queries = More Animal Crossing

Jonan Scheffler

March 31, 2020

230

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

0

28

inventing_friends.pdf

0

27

Inventing Friends: Actioncable + AVS = <3

0

100

Building HAL: Running Ruby with your Voice

1

110

Deploying MEAN on Heroku

2

50

0

86

Hacking Cognition

2

130

Other Decks in Programming

See All in Programming

脳の「省エネモード」をデバッグする～System 1（直感）と System 2（論理）の切り替え～

PRO

0

120

Graviton と Nitro と私

0

130

ZJIT: The Ruby 4 JIT Compiler / Ruby Release 30th Anniversary Party

1

270

Canon EOS R50 V と R5 Mark II 購入でみえてきた最近のデジイチ VR180 事情、そして VR180 静止画に活路を見出すまで

0

140

バックエンドエンジニアによる Amebaブログ K8s 基盤への CronJobの導入・運用経験

0

170

Combinatorial Interview Problems with Backtracking Solutions - From Imperative Procedural Programming to Declarative Functional Programming - Part 2

PRO

0

110

マスタデータ問題、マイクロサービスでどう解くか

0

120

開発に寄りそう自動テストの実現

2

1.4k

AIコーディングエージェント（NotebookLM）

0

230

Patterns of Patterns

0

320

Spinner 軸ズレ現象を調べたらレンダリング深淵に飲まれた #レバテックMeetup

0

170

Tinkerbellから学ぶ、Podで DHCPをリッスンする手法

0

140

Featured

See All Featured

コードの90%をAIが書く世界で何が待っているのか / What awaits us in a world where 90% of the code is written by AI

57

37k

How to Create Impact in a Changing Tech Landscape [PerfNow 2023]

55

3.2k

"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)

231

22k

What the history of the web can teach us about the future of AI

PRO

0

370

Keith and Marios Guide to Fast Websites

413

23k

Designing for humans not robots

254

26k

How to Align SEO within the Product Triangle To Get  Buy-In & Support - #RIMC

1

1.3k

Documentation Writing (for coders)

77

5.2k

Principles of Awesome APIs and How to Build Them.

127

17k

How To Stay Up To Date on Web Technology

791

250k

Beyond borders and beyond the search box: How to win the global "messy middle" with AI-driven SEO

0

22

Building Flexible Design Systems

yeseniaperezcruz

330

39k

Transcript