Postgres: query on huge (11gb ) index does not return
I don't know if my answer is accurate as we don't have much informations in your question, but perhaps you should consider one of this lead:


partitioning
partial indexes