Faster Queries = More Animal Crossing

Jonan Scheffler

March 31, 2020

160

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

21

inventing_friends.pdf

0

22

Inventing Friends: Actioncable + AVS = <3

0

91

Building HAL: Running Ruby with your Voice

1

82

Deploying MEAN on Heroku

2

42

0

77

Hacking Cognition

2

120

Other Decks in Programming

See All in Programming

LangChainの現在とv0.3にむけて

4

890

GraphQLの魅力を引き出すAndroidクライアント実装

3

400

Boost Performance and Developer Productivity with Jakarta EE 11

0

360

Swift Concurrencyとレースコンディション

1

410

rails_girls_is_my_gate_to_join_the_ruby_commuinty

0

190

Method Swizzlingを行うライブラリにおけるマルチモジュール設計

0

110

1人で挑むSwiftコンパイラ〜型システム入門編〜

0

340

月間4.5億回再生を超える大規模サービス TVer iOSアプリのリアーキテクチャ戦略 - iOSDC2024

1

820

GenU導入でCDKに初挑戦し、悪戦苦闘した話

0

160

Increased Performance and Developer Productivity with Jakarta EE 11

0

240

『ドメイン駆動設計をはじめよう』中核の業務領域

5

970

Web技術を駆使してユーザーの画面を「録画」する

13

6.5k

Featured

See All Featured

Creatively Recalculating Your Daily Design Routine

215

12k

XXLCSS - How to scale CSS and keep your sanity

246

1.3M

No one is an island. Learnings from fostering a developers community.

18

2.9k

Docker and Python

39

3k

VelocityConf: Rendering Performance Case Studies

322

23k

Practical Orchestrator

185

10k

Rebuilding a faster, lazier Slack

78

8.6k

Building Adaptive Systems

36

2.1k

The Mythical Team-Month

218

43k

4 Signs Your Business is Dying

179

21k

Imperfection Machines: The Place of Print at Facebook

263

13k

Web development in the modern age

204

10k

Transcript