Store computed aggregated query result in a column

[mild sparrow]

i want to store aggregated sum of child table rows in parent table. im mostly going to be performing reads on parent table, so i dont want to run a query every time to calculate the sum, but instead store it in a column of parent table. what is the Django way to achieve this?

[golden stone]

I'm not aware of any mechanisms in Django that allow for this. The PostgreSQL way to do this is a materialized view. https://www.postgresql.org/docs/current/rules-materializedviews.html