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

26

Inventing Friends: Actioncable + AVS = <3

0

97

Building HAL: Running Ruby with your Voice

1

100

Deploying MEAN on Heroku

2

49

0

84

Hacking Cognition

2

120

Other Decks in Programming

See All in Programming

CSC305 Lecture 14

PRO

0

210

エンジニアに事業やプロダクトを理解してもらうためにやってること

0

120

GC25 Recap: The Code You Reviewed is Not the Code You Built / #newt_gophercon_tour

0

140

SODA - FACT BOOK（JP）

1

9.2k

Pythonに漸進的に型をつける

1

150

Software Architecture

6

2.4k

TransformerからMCPまで（現代AIを理解するための羅針盤）

7

5.9k

kiroとCodexで最高のSpec駆動開発を！！数時間で web3ネイティブなミニゲームを作ってみたよ！

0

1.1k

ネストしたdata classの面倒な更新にさようなら！Lensを作って理解するArrowのOpticsの世界

1

250

pnpm に provenance のダウングレードを検出する PR を出してみた

1

180

なんでRustの環境構築してないのにRust製のツールが動くの？ / Why Do Rust-Based Tools Run Without a Rust Environment?

14

47k

Blazing Fast UI Development with Compose Hot Reload (droidcon London 2025)

0

450

Featured

See All Featured

Designing Dashboards & Data Visualisations in Web Apps

231

54k

Mobile First: as difficult as doing things right

225

10k

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

PRO

192

56k

Raft: Consensus for Rubyists

140

7.2k

How to Create Impact in a Changing Tech Landscape [PerfNow 2023]

55

3k

The Power of CSS Pseudo Elements

80

6k

Bash Introduction

615

210k

PRO

32

15k

Automating Front-end Workflow

1371

200k

ReactJS: Keep Simple. Everything can be a component!

666

130k

Thoughts on Productivity

72

4.9k

[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails

37

2.6k

Transcript