Django python and Postgres Performance issues good explained

 

 

Nice speech with good  explained example about performance in Django and Postgres. 
There is also a code examples and it was created by a beautiful girl.
That makes this tutorial even more pleasant to watch.

https://github.com/citusdata/citus-django-example-ad-analytics

Note from this video..


- Analyze your code with logo better externally because your logs can also become a botel neck for your filesystem.
- Avoid nested loops, like in all languages and technologies.
- Limiting what you are selecting with prefetch_related
- Use pagination

- Add indexes to fields on models where you select, filter of sort with. 


See more tips about Postgres performance in this video. More information about how in when scaling up with Postgres. 

 




Comments