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

25

Inventing Friends: Actioncable + AVS = <3

0

97

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

RDoc meets YARD

2

130

Langfuseと歩む生成AI活用推進

3

300

Claude Codeで挑むOSSコントリビュート

0

180

技術的負債で信頼性が限界だったWordPress運用をShifterで完全復活させた話

1

2.1k

「リーダーは意思決定する人」って本当？～学びを現場で活かす、リーダー4ヶ月目の試行錯誤～

0

240

CSC305 Summer Lecture 12

PRO

0

120

新世界の理解

0

140

管你要 trace 什麼、bpftrace 用下去就對了 — COSCUP 2025

0

470

Microsoft Orleans, Daprのアクターモデルを使い効率的に開発、デプロイを行うためのSekibanの試行錯誤 / Sekiban: Exploring Efficient Development and Deployment with Microsoft Orleans and Dapr Actor Models

0

210

SOCI Index Manifest v2が出たので調べてみた / Introduction to SOCI Index Manifest v2

1

110

モバイルアプリからWebへの横展開を加速した話_Claude_Code_実践術.pdf

0

270

20250808_AIAgent勉強会_ClaudeCodeデータ分析の実運用〜競馬を題材に回収率100%の先を目指すメソッドとは〜

0

210

Featured

See All Featured

Git: the NoSQL Database

PRO

431

65k

Distributed Sagas: A Protocol for Coordinating Microservices

333

22k

The Language of Interfaces

160

25k

Mobile First: as difficult as doing things right

223

9.9k

Art, The Web, and Tiny UX

302

21k

Making Projects Easy

117

6.3k

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

50

5.5k

Documentation Writing (for coders)

73

5k

What's in a price? How to price your products and services

246

12k

実際に使うSQLの書き方徹底解説 / pgcon21j-tutorial

PRO

183

54k

Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything

31

2.5k

GraphQLの誤解/rethinking-graphql

71

11k

Transcript