Inspecting the index size in PostgreSQL
April 21, 2025
0 comments
Category: PostgreSQL
The 3 queries I use with pg_stat_statements to analyze slow PostgreSQL queries
September 30, 2024
0 comments
Category: PostgreSQL
How to sort case insensitively with empty strings last in Django
April 3, 2022
1 comment
Categories: Django, Python, PostgreSQL
Update to speed comparison for Redis vs PostgreSQL storing blobs of JSON
September 30, 2019
2 comments
Categories: Redis, Nginx, Web Performance, Python, Django, PostgreSQL
How much faster is Redis at storing a blob of JSON compared to PostgreSQL?
September 28, 2019
65 comments
Categories: Python, PostgreSQL, Redis
Best way to count distinct indexed things in PostgreSQL
March 21, 2019
3 comments
Categories: Django, PostgreSQL
Django ORM optimization story on selecting the least possible
February 22, 2019
16 comments
Categories: Web development, Django, Python, PostgreSQL
How I performance test PostgreSQL locally on macOS
December 10, 2018
2 comments
Categories: Web development, macOS, PostgreSQL
Best EXPLAIN ANALYZE benchmark script
April 19, 2018
0 comments
Categories: Python, PostgreSQL
Efficient many-to-many field lookup in Django REST Framework
April 11, 2018
1 comment
Categories: Python, Django, PostgreSQL
Show size of every PostgreSQL database you have
February 7, 2018
0 comments
Category: PostgreSQL
Conditional aggregation in Django 2.0
January 12, 2018
4 comments
Categories: Python, Django, PostgreSQL
Synonyms with elasticsearch-dsl
December 5, 2017
0 comments
Categories: Python, Web development, PostgreSQL
Simple or fancy UPSERT in PostgreSQL with Django
October 11, 2017
7 comments
Categories: Python, Web development, Django, PostgreSQL
crontabber now supports locking, both high- and low-level
March 4, 2017
0 comments
Categories: Python, Mozilla, PostgreSQL