a bit more hands-on, but it's possible to create a functional index to improve json query performance in postgres:

https://postgres.heroku.com/blog/past/2013/6/5/javascript_in...