It looks like the next release of Django will take seriious strides to solve a lot of the n+1 headaches, https://docs.djangoproject.com/en/dev/releases/6.1/#model-fi....

Also, I doubt solving Instagram-level scale issues is on the top ten list of concerns for this project. Just getting something out there and gaining users is way more important than solving far future scaling issues.