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

34

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

65

0

91

Hacking Cognition

2

140

Other Decks in Programming

See All in Programming

30年振りにコンパイラの定数整数除算を改善した

7

3.6k

今さら聞けない .NET CLI

0

210

typoなんかねぇよ

0

260

Claude Code全社展開のためにやったことn選～プラグイン302個・コミッター271人を支えるために～

5

1.6k

AWS DevOps AgentのAzure接続機能を検証して見えた活用法／Use Cases Verified for the AWS DevOps Agent's Azure Connectivity Feature

1

260

片田舎のおっさん、 Swift Buildのダイアモンド問題解決の不具合修正PRを出すが、解決方法がキャッシュをしないようにすることであり、ビルド時間が伸びると言われてマージされないので高速化もする/swiftbuild

0

230

0

500

Dockerfile CMD for Node.js

0

110

人間の目はかわらない、だからJPEGは30年もつ

12

19k

Cloudflare is Agents

0

180

FDEが実現するAI駆動経営の現在地

2

290

GDG Korea Android: 2026 I/O Extended ~ What's new in Android development tools

0

240

Featured

See All Featured

Optimising Largest Contentful Paint

37

3.9k

Navigating Algorithm Shifts & AI Overviews - #SMXNext

1

1.6k

Collaborative Software Design: How to facilitate domain modelling decisions

1

280

It's Worth the Effort

188

29k

PRO

35

15k

Marketing to machines

1

5.7k

Understanding Cognitive Biases in Performance Measurement

32

3k

jQuery: Nuts, Bolts and Bling

66

8.5k

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

35

2.5k

Max Prin - Stacking Signals: How International SEO Comes Together (And Falls Apart)

PRO

0

420

AI in Enterprises - Java and Open Source to the Rescue

0

1.4k

Music & Morning Musume

47

7.3k

Transcript