Faster Queries = More Animal Crossing

Jonan Scheffler

March 31, 2020

210

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

24

inventing_friends.pdf

0

23

Inventing Friends: Actioncable + AVS = <3

0

93

Building HAL: Running Ruby with your Voice

1

90

Deploying MEAN on Heroku

2

43

0

79

Hacking Cognition

2

120

Other Decks in Programming

See All in Programming

Jakarta EE meets AI

0

860

Learning Kotlin with detekt

1

220

DevNexus - Create AI Infused Java Apps with LangChain4j

0

150

仕様変更に耐えるための"今の"DRY原則を考える

9

3.3k

変化の激しい時代における、こだわりのないエンジニアの強さ

satoshi256kbyte

1

870

Drawing Heighway’s Dragon- Recursive Function Rewrite- From Imperative Style in Pascal 64 To Functional Style in Scala 3

0

180

Djangoにおける複数ユーザー種別認証の設計アプローチ@DjangoCongress JP 2025

4

520

CIBMTR振り返り＋敗北から学ぶコンペの取り組み方反省

1

240

[JAWS DAYS 2025] 最近の DB の競合解決の仕組みが分かった気になってみた

0

200

PHPのバージョンアップ時にも役立ったAST

0

250

5分で理解する SOLID 原則 #phpcon_nagoya

1

430

気がついたら子供が社会人になって自分と同じモバイルアプリエンジニアになった件 / Parent-Child Engineers

0

130

Featured

See All Featured

29

14k

Building Applications with DynamoDB

93

6.3k

Java REST API Framework Comparison - PWX 2021

29

8.4k

Optimizing for Happiness

377

70k

A better future with KSS

238

17k

Creating an realtime collaboration tool: Agile Flush - .NET Oxford

28

1.9k

VelocityConf: Rendering Performance Case Studies

328

24k

Large-scale JavaScript Application Architecture

511

110k

Optimising Largest Contentful Paint

34

3.1k

Save Time (by Creating Custom Rails Generators)

29

1.1k

Testing 201, or: Great Expectations

42

7.2k

How To Stay Up To Date on Web Technology

790

250k

Transcript