On May 14, 2015, at 10:30 PM, Me Sulphur <mesulp...@gmail.com> wrote: > > * It is a large key-value pair table (approaching ~ 1 bn rows) with an MD5 > key and JSON for value. The look ups depend on the business logic but are > necessary. Nevertheless, there are no more than 10-12 queries executed by > combining key look ups using WHERE IN queries and pg is surprisingly good > with IN queries.
If this is the case, then I strongly recommend switching to a NoSQL DB. You aren’t using any of the Django ORM functionality, so there’s no need to switch to django-nonrel. Almost all of them are faster at key/value returns than PostgreSQL. Peter of the Norse rahmc...@radio1190.org -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/794491DD-ADB8-422A-AE03-0D4D8546E4E2%40Radio1190.org. For more options, visit https://groups.google.com/d/optout.
