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

30

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

58

0

90

Hacking Cognition

2

140

Other Decks in Programming

See All in Programming

IBM Bobを活用したレガシーアプリの最新化

PRO

1

240

正しくソフトウェアを作る、前提を疑うための認知の視点 / doubt-premise

21

7.2k

Spec Driven Development | AI Summit Lisbon

PRO

0

230

なぜ型を書くのか？ TSKaigi2026で改めて考える #tskaigi_smarthr

0

190

例外の正しい扱い方そのエラー try-catchして大丈夫？

0

320

AIで効率化できた業務・日常

0

160

Vue × Nuxt × Oxc どこまで使える？実運用の現在地

0

350

Hunting Vulnerabilities in Symfony with LLMs

0

570

ローカルLLMでどこまでコードが書けるか -縮小版 /　How much code can be written on a local LLM Shortened

2

170

コンテキストの使い捨てをやめる — ビジネスルール駆動開発と miko —

0

260

LaravelLive Japan の裏方のすべて — 第188回 PHP勉強会＠東京 (2026-06-24)

2

150

Performance Engineering for Everyone

0

250

Featured

See All Featured

Chasing Engaging Ingredients in Design

0

230

HTML-Aware ERB: The Path to Reactive Rendering @ RubyCon 2026, Rimini, Italy

2

280

We Analyzed 250 Million AI Search Results: Here's What I Found

1

1.4k

How Fast Is Fast Enough? [PerfNow 2025]

3

640

Deep Space Network (abreviated)

0

220

The Organizational Zoo: Understanding Human Behavior Agility Through Metaphoric Constructive Conversations (based on the works of Arthur Shelley, Ph.D)

PRO

0

380

How To Speak Unicorn (iThemes Webinar)

1

500

Why Mistakes Are the Best Teachers: Turning Failure into a Pathway for Growth

0

180

Why Our Code Smells

PRO

340

58k

Reality Check: Gamification 10 Years Later

0

2.2k

[SF Ruby Conf 2025] Rails X

2

1.1k

Getting science done with accelerated Python computing platforms

2

250

Transcript