Faster Queries = More Animal Crossing

Jonan Scheffler

March 31, 2020

180

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

23

inventing_friends.pdf

0

22

Inventing Friends: Actioncable + AVS = <3

0

92

Building HAL: Running Ruby with your Voice

1

84

Deploying MEAN on Heroku

2

42

0

77

Hacking Cognition

2

120

Other Decks in Programming

See All in Programming

ふかぼれ！CSSセレクターモジュール / Fukabore! CSS Selectors Module

0

150

C++でシェーダを書く

6

4.1k

Nurturing OpenJDK distribution: Eclipse Temurin Success History and plan

0

890

Less waste, more joy, and a lot more green: How Quarkus makes Java better

0

100

ローコードSaaSのUXを向上させるためのTypeScript

1

610

Contemporary Test Cases

0

130

CSC509 Lecture 09

0

140

アジャイルを支えるテストアーキテクチャ設計/Test Architecting for Agile

9

3.3k

RubyLSPのマルチバイト文字対応

0

120

ECS Service Connectのこれまでのアップデートと今後のRoadmapを見てみる

2

250

Amazon Qを使ってIaCを触ろう！

0

400

as（型アサーション）を書く前にできること

10

2.6k

Featured

See All Featured

Designing Dashboards & Data Visualisations in Web Apps

229

52k

Save Time (by Creating Custom Rails Generators)

27

840

The Psychology of Web Performance [Beyond Tellerrand 2023]

44

2.2k

The Art of Programming - Codeland 2020

52

13k

XXLCSS - How to scale CSS and keep your sanity

246

1.3M

Fight the Zombie Pattern Library - RWD Summit 2016

232

17k

jQuery: Nuts, Bolts and Bling

61

7.5k

VelocityConf: Rendering Performance Case Studies

325

24k

The Cult of Friendly URLs

78

6k

The Cost Of JavaScript in 2023

45

6.7k

Writing Fast Ruby

627

61k

Intergalactic Javascript Robots from Outer Space

269

27k

Transcript