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

28

inventing_friends.pdf

0

28

Inventing Friends: Actioncable + AVS = <3

0

100

Building HAL: Running Ruby with your Voice

1

110

Deploying MEAN on Heroku

2

50

0

86

Hacking Cognition

2

130

Other Decks in Programming

See All in Programming

ZJIT: The Ruby 4 JIT Compiler / Ruby Release 30th Anniversary Party

1

280

クラウドに依存しないS3を使った開発術

0

160

Developing static sites with Ruby

0

330

AIコーディングエージェント（skywork）

0

200

C-Shared Buildで突破するAI Agent バックテストの壁

0

420

PC-6001でPSG曲を鳴らすまでを全部NetBSD上の Makefile に押し込んでみた / osc2025hiroshima

0

180

まだ間に合う！Claude Code元年をふりかえる

5

900

Navigating Dependency Injection with Metro

1

180

脳の「省エネモード」をデバッグする～System 1（直感）と System 2（論理）の切り替え～

PRO

0

120

AtCoder Conference 2025「LLM時代のAHC」

2

590

Navigation 3: 적응형 UI를 위한 앱 탐색

1

460

ゆくKotlin くるRust

1

160

Featured

See All Featured

The Psychology of Web Performance [Beyond Tellerrand 2023]

49

3.2k

The AI Revolution Will Not Be Monopolized: How open-source beats economies of scale, even for LLMs

PRO

2

2.8k

HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy

PRO

0

100

Distributed Sagas: A Protocol for Coordinating Microservices

333

22k

Let's Do A Bunch of Simple Stuff to Make Websites Faster

508

140k

Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End

254

22k

Build your cross-platform service in a week with App Engine

234

18k

Sam Torres - BigQuery for SEOs

PRO

0

140

Building Better People: How to give real-time feedback that sticks.

370

20k

Documentation Writing (for coders)

77

5.2k

Bioeconomy Workshop: Dr. Julius Ecuru, Opportunities for a Bioeconomy in West Africa

PRO

0

31

The World Runs on Bad Software

PRO

72

12k

Transcript