Stories by haki

Unconventional PostgreSQL Optimizations

Reliable Django Signals

Heroku has been running a second copy of my scheduler instance

Lesser Known PostgreSQL Features

One Database Transaction Too Many

Practical SQL for Data Analysis: What you can do without Pandas

New Features in Django 3.2

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

Re-Introducing Hash Indexes in PostgreSQL

Exhaustiveness Checking in Python Using Mypy

The surprising impact of medium-size texts on PostgreSQL performance

Simple Anomaly Detection Using Plain SQL

Some SQL Tricks of an Application DBA

Stop Using Datetime.now in Python

Understand Group by in Django with SQL

Common Mistakes and Missed Optimization Opportunities in SQL

“Export to Excel” Almost Killed Our System

Fastest Way to Load Data into PostgreSQL Using Python

How We Solved a Storage Problem in PostgreSQL Without Adding Storage