⬅︎ Back to Django ORM optimization story on selecting the least possible
Best optimizationI start thinking to suggest this solution before reading the "Update" section.P.S. They added "MD5" database function in Django dev:https://docs.djangoproject.com/en/dev/ref/models/database-functions/#md5
Try this: from django.contrib.postgres.aggregates import StringAgg from django.db.models import Func result = Song.objects.filter( artist=artist ).aggregate( names_hash=Func( StringAgg('name', ''), function='md5' ) )
Comment
Best optimization
I start thinking to suggest this solution before reading the "Update" section.
P.S. They added "MD5" database function in Django dev:
https://docs.djangoproject.com/en/dev/ref/models/database-functions/#md5
Parent comment
Try this: from django.contrib.postgres.aggregates import StringAgg from django.db.models import Func result = Song.objects.filter( artist=artist ).aggregate( names_hash=Func( StringAgg('name', ''), function='md5' ) )