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

24

inventing_friends.pdf

0

23

Inventing Friends: Actioncable + AVS = <3

0

95

Building HAL: Running Ruby with your Voice

1

100

Deploying MEAN on Heroku

2

44

0

80

Hacking Cognition

2

120

Other Decks in Programming

See All in Programming

Agent Rules as Domain Parser

1

440

AIにコードを生成するコードを作らせて、再現性を担保しよう！ / Let AI generate code to ensure reproducibility

7

6.1k

TypeScript だけを書いて Tauri でデスクトップアプリを作ろう / Tauri with only TypeScript

2

570

Prism.parseで 300本以上あるエンドポイントに接続できる権限の一覧表を作ってみた

1

100

がんばりすぎないコーディングルール運用術

1

210

TypeScript エンジニアが Android 開発の世界に飛び込んだ話

6

1k

推論された型の移植性エラーTS2742に挑む

0

170

ワイがおすすめする新潟の食 / 20250530phpconf-niigata-eve

0

290

プロダクト改善のために新しいことを始める -useContextからの卒業、Zustandへ-

rebase_engineering

1

110

Practical Tips and Tricks for Working with  Compose Multiplatform Previews (mDevCamp 2025)

0

110

Efficiency and Rock 'n’ Roll (Really!)

0

660

人には人それぞれのサービス層がある

3

630

Featured

See All Featured

Keith and Marios Guide to Fast Websites

411

22k

146

16k

Helping Users Find Their Own Way: Creating Modern Search Experiences

29

2.6k

A Modern Web Designer's Workflow

693

190k

jQuery: Nuts, Bolts and Bling

63

7.8k

Why Our Code Smells

337

57k

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

30

2.1k

Stop Working from a Prison Cell

269

20k

Raft: Consensus for Rubyists

138

7k

We Have a Design System, Now What?

52

7.6k

Optimizing for Happiness

378

70k

Building Flexible Design Systems

yeseniaperezcruz

329

39k

Transcript