Faster Queries = More Animal Crossing

Jonan Scheffler

March 31, 2020

220

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

26

inventing_friends.pdf

0

24

Inventing Friends: Actioncable + AVS = <3

0

96

Building HAL: Running Ruby with your Voice

1

100

Deploying MEAN on Heroku

2

49

0

81

Hacking Cognition

2

120

Other Decks in Programming

See All in Programming

ReadMoreTextView

1

450

Cline指示通りに動かない？ AI小説エージェントで学ぶ指示書の書き方と自動アップデートの仕組み

1

570

Is Xcode slowly dying out in 2025?

1

180

CursorはMCPを使った方が良いぞ

0

160

Railsアプリケーションとパフォーマンスチューニングー秒間5万リクエストのモバイルオーダーシステムを支える事例ー Rubyセミナー大阪

4

860

#kanrk08 / 公開版 PicoRubyとマイコンでの自作トレーニング計測装置を用いたワークアウトの理想と現実

1

110

データの民主化を支える、透明性のあるデータ利活用への挑戦 2025-06-25 Database Engineering Meetup#7

0

290

来たるべき 8.0 に備えて React 19 新機能と React Router 固有機能の取捨選択とすり合わせを考える

2

830

すべてのコンテキストを、ユーザー価値に変える

2

510

[初登壇＠jAZUG]アプリ開発者が気になるGoogleCloud/Azure＋wasm/wasi

0

130

PostgreSQLのRow Level SecurityをPHPのORMで扱う Eloquent vs Doctrine #phpcon #track2

1

220

What Spring Developers Should Know About Jakarta EE

0

160

Featured

See All Featured

Easily Structure & Communicate Ideas using Wireframe

194

16k

Imperfection Machines: The Place of Print at Facebook

267

13k

ReactJS: Keep Simple. Everything can be a component!

667

120k

Designing for Performance

609

69k

Building Applications with DynamoDB

95

6.5k

The Illustrated Children's Guide to Kubernetes

48

50k

Building a Scalable Design System with Sketch

462

33k

Why Our Code Smells

337

57k

[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails

35

2.3k

Java REST API Framework Comparison - PWX 2021

31

8.6k

Statistics for Hackers

799

220k

The Power of CSS Pseudo Elements

77

5.8k

Transcript