Faster Queries = More Animal Crossing

Jonan Scheffler

March 31, 2020

130

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

16

inventing_friends.pdf

0

21

Inventing Friends: Actioncable + AVS = <3

0

86

Building HAL: Running Ruby with your Voice

1

76

Deploying MEAN on Heroku

2

41

0

67

Hacking Cognition

2

110

Other Decks in Programming

See All in Programming

プールにゆこう

2

120

What We Can Learn From OSS

0

400

HUIT新歓2024「競技プログラミング、やってみませんか？」

1

250

Folding Cheat Sheet #2

0

110

9年開発を牽引して見えてきた、共通化すべきものと個別でつくるもの ~プログラム言語~

1

640

GitHub Actionsで泣かないためにやっておきたい設定 / Recommended GHA settings to avoid crying

3

480

1인 개발자로 행복하게 살기 - GDG 송도 헬로월드 2024

1

5.6k

OpenAPIを中心に考えるAPI開発入門 / Introduction to API Development with a Focus on OpenAPI

2

100

[技育CAMPアカデミア]アイディアを形に！【超入門】スマホアプリ開発〜リリースまでの流れをご紹介

0

340

SwiftUI Performance 不要なViewの再描画と更新を抑える

1

150

puregoの活用例

aethiopicuschan

0

220

脱・初心者！脱・マネコン！AWS CDKを使ってみませんか！？

0

300

Featured

See All Featured

Music & Morning Musume

40

5.6k

個人開発の失敗を避けるイケてる考え方 / tips for indie hackers

60

14k

What’s in a name? Adding method to the madness

productmarketing

15

2.6k

Understanding Cognitive Biases in Performance Measurement

6

990

Web development in the modern age

201

10k

Clear Off the Table

82

310k

Optimising Largest Contentful Paint

7

2.3k

Statistics for Hackers

789

220k

Designing with Data

95

4.8k

9

4.5k

Building Your Own Lightsaber

97

5.7k

Building a Modern Day  E-commerce SEO Strategy

16

6.3k

Transcript