Faster Queries = More Animal Crossing

Jonan Scheffler

March 31, 2020

170

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

21

inventing_friends.pdf

0

22

Inventing Friends: Actioncable + AVS = <3

0

91

Building HAL: Running Ruby with your Voice

1

82

Deploying MEAN on Heroku

2

42

0

77

Hacking Cognition

2

120

Other Decks in Programming

See All in Programming

1

210

Progressive Web Apps for Rails developers

2

530

VS Code extension: ドラッグ&ドロップでファイルを並び替える

0

160

sqlcを利用してsqlに型付けを

0

230

선언형 UI를 학습할 때 알아둬야하는 키워드들

0

120

Unlocking Python's Core Magic

0

120

いまあるチームにフィットさせる Serverless そして Platform Engineeringへの挑戦 / Serverless Fits the Team You Have and Platform Engineering

2

1.4k

NEWTにおけるiOS18対応の進め方

0

190

The Efficiency Paradox and How to Save Yourself and the World

0

150

Re:PandasAI：生成AIがデータ分析業務にもたらすパラダイムシフト【増補改訂版】

1

860

DjangoNinjaで高速なAPI開発を実現する

0

480

M5Stack に色々な M5ユニットをつないで扱う為の新たなアプローチ

0

200

Featured

See All Featured

Imperfection Machines: The Place of Print at Facebook

264

13k

A Philosophy of Restraint

202

16k

JavaScript: Past, Present, and Future - NDC Porto 2020

45

4.9k

The Language of Interfaces

154

24k

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

92

16k

Optimising Largest Contentful Paint

31

2.8k

Large-scale JavaScript Application Architecture

509

110k

Evolution of real-time – Irina Nazarova, EuRuKo, 2024

2

220

Performance Is Good for Brains [We Love Speed 2024]

1

250

97

6.7k

GraphQLとの向き合い方2022年版

43

13k

Atom: Resistance is Futile

261

25k

Transcript