Haki Benita • 12/10/2017

Django Admin Range-Based Date Hierarchy

The article details a performance regression in a Django Admin list view for a transactions model with millions of rows. It investigates how the default date hierarchy filter generates inefficient SQL queries (using EXTRACT on a full year range) and proposes a solution using a custom range-based filter for better PostgreSQL index utilization and faster page loads.

0 comments

#performance #postgresql #django