Skip to content

Haki Benita personal blog

Common Mistakes and Missed Optimization Opportunities in SQL

hakibenita.com published 2019-11-21

Made by Developers and Non-Developers

Read on hakibenita.com → Discuss on HN (66) Archived copy

Points: 179
HN comments: 66
Submissions: 1
Cited by: 0 commenters

Databases & Data Software Engineering 2019

On Hacker News

Submitted	Title on HN	Points	Comments
Nov 21, 2019	Common Mistakes and Missed Optimization Opportunities in SQL by haki	179	66

More from Haki Benita

All 11 posts →

Lesser-known Postgres features

2021702 points180 comments Databases & Data details

Practical SQL for Data Analysis

2021602 points191 comments Databases & Data details

Simple Anomaly Detection Using Plain SQL

2021512 points47 comments Databases & Data details

Unconventional PostgreSQL Optimizations

2026431 points69 comments Databases & Data details

An unexpected find that freed 20GB of unused index space in PostgreSQL

2021375 points140 comments Databases & Data details

Some SQL Tricks of an Application DBA

2020327 points68 comments Databases & Data details

Related posts from the same era

Apple open-sources FoundationDB

FoundationDB Blog20182,136 points441 comments details

Personal and social information of 1.2B people discovered in data leak

Data Viper Blog20191,439 points419 comments details

CRDTs are the future

Joseph Gentle20201,181 points357 commentscited by 12 details

Congress votes to make open government data the default in the United States

E Pluribus Unum20181,130 points154 comments details

Things I wished more developers knew about databases

Jaana Dogan20201,011 points445 comments details

JupyterLab is ready for users

Jupyter Blog2018958 points248 comments details