Faster Queries = More Animal Crossing

Jonan Scheffler

March 31, 2020

280

Faster Queries = More Animal Crossing

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

Jonan Scheffler

March 31, 2020

More Decks by Jonan Scheffler

See All by Jonan Scheffler

Sleeping in Airports: The Magical, Terrible Life of a Developer Advocate

0

36

inventing_friends.pdf

0

35

Inventing Friends: Actioncable + AVS = <3

0

100

Building HAL: Running Ruby with your Voice

1

120

Deploying MEAN on Heroku

2

66

0

92

Hacking Cognition

2

140

Other Decks in Programming

See All in Programming

Atomic Design, Enforced: Scaling Mobile Design Systems (next.app devCon / droidCon Berlin 2026)

PRO

0

170

Compiling a real-world CLI tool to native with Static Hermes

0

120

re:Inventに行く前に知っておきたい現地参加のノウハウ

0

430

The Rails Doctrine Decade

2

590

iOS 27でニュースアプリはどう変わる！？〜日経電子版の新機能対応と、開発事例から〜

7

13k

【加筆修正版】Laravel のアプリケーションをどこにデプロイするか #phpcon_ehime

0

150

作って学ぶSpring BootのAuto Configuration / JJUG Night Seminar 2026-10-19

0

140

残高管理から台帳サービスへの進化

1

200

Rでドレミ/Do-Re-Mi_with_R

0

130

TechTown - Creating Composable Callables in Contemporary C++

0

130

複雑なUIコンポーネントとの⻑い付き合い⽅：波及するバグからテスト戦略を経て、安全な再設計へ

0

410

AWS CDKのカスタムリソースでContinuum（旧Security Agent）を実装した話 | Implementing Continuum (formerly Security Agent) via AWS CDK Custom Resource

2

150

Featured

See All Featured

PRO

2

870

AI in Enterprises - Java and Open Source to the Rescue

0

1.5k

30

1.6k

Embracing the Ebb and Flow

88

5.2k

Navigating Team Friction

192

16k

2

960

PRO

5

54k

The Director’s Chair: Orchestrating AI for Truly Effective Learning

1

330

Git: the NoSQL Database

PRO

433

67k

How to make the Groovebox

2

2.5k

Balancing Empowerment & Direction

6

1.3k

Ethics towards AI in product and experience design

2

430

Transcript