Faster Queries = More Animal Crossing

Jonan Scheffler

March 31, 2020

230

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

26

inventing_friends.pdf

0

24

Inventing Friends: Actioncable + AVS = <3

0

96

Building HAL: Running Ruby with your Voice

1

100

Deploying MEAN on Heroku

2

49

0

81

Hacking Cognition

2

120

Other Decks in Programming

See All in Programming

AI Agent 時代のソフトウェア開発を支える AWS Cloud Development Kit (CDK)

6

800

PipeCDのプラグイン化で目指すところ

1

300

Azure AI Foundryではじめてのマルチエージェントワークフロー

0

200

Deep Dive into ~/.claude/projects

14

14k

なぜ「共通化」を考え、失敗を繰り返すのか

1

680

AI コーディングエージェントの時代へ：JetBrains が描く開発の未来

1

200

Model Pollution

1

160

Agentic Coding: The Future of Software Development with Agents

0

130

Startups on Rails in Past, Present and Future–Irina Nazarova, RailsConf 2025

0

250

Modern Angular with Signals and Signal Store:New Rules for Your Architecture @enterJS Advanced Angular Day 2025

0

270

ペアプロ × 生成AI 現場での実践と課題について / generative-ai-in-pair-programming

2

21k

新メンバーも今日から大活躍！SREが支えるスケールし続ける組織のオンボーディング

5

8.7k

Featured

See All Featured

Stop Working from a Prison Cell

271

21k

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

30

2.2k

GraphQLの誤解/rethinking-graphql

71

11k

Sharpening the Axe: The Primacy of Toolmaking

44

2.4k

Building an army of robots

306

45k

[RailsConf 2023] Rails as a piece of cake

55

5.7k

It's Worth the Effort

185

28k

Six Lessons from altMBA

28

3.9k

The Art of Programming - Codeland 2020

54

13k

Exploring the Power of Turbo Streams & Action Cable | RailsConf2023

34

5.9k

Why You Should Never Use an ORM

58

9.5k

The World Runs on Bad Software

70

11k

Transcript