Faster Queries = More Animal Crossing

Jonan Scheffler

March 31, 2020

280

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

34

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

65

0

92

Hacking Cognition

2

140

Other Decks in Programming

See All in Programming

iOSDCのペンライトを自動制御したい！

0

100

Omarchy Tokyo やると聞いて UMPC 買ってセットアップしてきた

0

170

Java 27新機能 / Java 27 new features

2

180

MVNOの申込からeSIM開通までをiOSアプリでつなぐ- 本人確認・MNP・通信事業者基盤をまたぐ実装

0

490

[ハンズオン]AIへの指示だけで「五目並べ」を作ってみよう

satoshi256kbyte

1

250

AI活用は、個人から組織へ｜マルチプレイヤーエージェントハーネス「QM」の社内活用事例 / AI use is moving from individuals to orgs

1

270

WebRTC映像をAirPlayに対応させる挑戦.pdf

monolithic_adam

0

320

ゲームコントローラやキーボードのファームウェアをSwiftで書く

kishikawakatsumi

1

260

re:Inventに行く前に知っておきたい現地参加のノウハウ

0

170

TiDB Cloudのカスタムコントローラーによるオートスケール対応

0

140

iOSDC Japan 2026 - Swiftで作って学ぼう！データベース自作入門

2

370

Everything will be SERVERLESS — 信じて運用した10年の経験値 / Everything Will be Serverless — Lessons Learned from 10 Years of Operational Experience

PRO

1

540

Featured

See All Featured

Design and Strategy: How to Deal with People Who Don’t "Get" Design

133

19k

Measuring & Analyzing Core Web Vitals

9

1k

Efficient Content Optimization with Google Search Console & Apps Script

PRO

1

880

Skip the Path - Find Your Career Trail

1

240

Primal Persuasion: How to Engage the Brain for Learning That Lasts

0

490

Exploring the Power of Turbo Streams & Action Cable | RailsConf2023

37

6.6k

More Than Pixels: Becoming A User Experience Designer

3

540

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

35

2.6k

Writing Fast Ruby

630

63k

Sam Torres - BigQuery for SEOs

PRO

0

550

Ethics towards AI in product and experience design

2

390

Sharpening the Axe: The Primacy of Toolmaking

46

3k

Transcript