Re: [PERFORM] Slow query in JDBC - Mailing list pgsql-performance

From Julien Rouhaud
Subject Re: [PERFORM] Slow query in JDBC
Date
Msg-id CAOBaU_beQv5GoeaZT3Jk382MtsfTfMUmXaN9cS_ocunw4UKqxA@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Slow query in JDBC  (Subramaniam C <subramaniam31784@gmail.com>)
Responses Re: [PERFORM] Slow query in JDBC
List pgsql-performance
On Thu, Sep 28, 2017 at 10:58 AM, Subramaniam C
<subramaniam31784@gmail.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).


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Subramaniam C
Date:
Subject: Re: [PERFORM] Slow query in JDBC
Next
From: Pavy Philippe
Date:
Subject: Re: [PERFORM] Slow query in JDBC