Tuning Django ORM (part 1): Text Queries
Concerning text queries, Django ORM offers several helper functions. However, some of those are not backed by a database index and will be slow. Fortunately, on PostgreSQL these searches can be sped up with GIN or GIST indexes quite easily.
This article will focus on Django 1.6 with a backing PostgreSQL. It probably applies to Django 1.7, as well.
The Django ORM layer offers some useful functionality when it comes to text search:
[Mehr]