On Thu, Sep 28, 2017 at 10:58 AM, Subramaniam C
<subramaniam31784(at)gmail(dot)com> wrote:
> I configured cursor_tuple_fraction to 1 but still I am facing the same
> issue.
Can you show explain (analyze, buffers) of the query when run from
psql and run from application (you can use auto_explain for that if
needed, see https://www.postgresql.org/docs/current/static/auto-explain.html)