In this article, the author explains three methods to optimize the GiST index scanning to limit resource wastage in PostgreSQL.
