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