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

32

Inventing Friends: Actioncable + AVS = <3

0

100

Building HAL: Running Ruby with your Voice

1

110

Deploying MEAN on Heroku

2

51

0

86

Hacking Cognition

2

130

Other Decks in Programming

See All in Programming

CSC307 Lecture 09

PRO

1

840

Oxlintはいいぞ

5

1.4k

組織で育むオブザーバビリティ

0

180

開発者から情シスまで - 多様なユーザー層に届けるAPI提供戦略 / Postman API Night Okinawa 2026 Winter

0

210

登壇資料を作る時に意識していること #登壇資料_findy

4

1.6k

AIエージェントのキホンから学ぶ「エージェンティックコーディング」実践入門

masahiro_nishimi

6

610

カスタマーサクセス業務を変革したヘルススコアの実現と学び

0

730

HTTPプロトコル正しく理解していますか？〜かわいい猫と共に学ぼう。ฅ^•ω•^ฅ ﾆｬ〜

2

690

humanlayerのブログから学ぶ、良いCLAUDE.mdの書き方

0

200

Fluid Templating in TYPO3 14

0

130

Oxlint JS plugins

1

1k

それ、本当に安全？ファイルアップロードで見落としがちなセキュリティリスクと対策

7

4k

Featured

See All Featured

Bridging the Design Gap: How Collaborative Modelling removes blockers to flow between stakeholders and teams @FastFlow conf

0

450

Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]

11

830

Embracing the Ebb and Flow

88

5k

世界の人気アプリ100個を分析して見えたペイウォール設計の心得

PRO

66

37k

Principles of Awesome APIs and How to Build Them.

128

17k

AI Search: Implications for SEO and How to Move Forward - #ShenzhenSEOConference

1

1.1k

Ethics towards AI in product and experience design

2

200

How STYLIGHT went responsive

100

6k

Leveraging LLMs for student feedback in introductory data science courses - posit::conf(2025)

0

160

Distributed Sagas: A Protocol for Coordinating Microservices

333

22k

Tips & Tricks on How to Get Your First Job In Tech

0

440

Leading Effective Engineering Teams in the AI Era

9

1.6k

Transcript