Re: [PERFORM] Slow query in JDBC

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: [PERFORM] Slow query in JDBC
Дата
Msg-id CAOBaU_beQv5GoeaZT3Jk382MtsfTfMUmXaN9cS_ocunw4UKqxA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Slow query in JDBC  (Subramaniam C <subramaniam31784@gmail.com>)
Ответы Re: [PERFORM] Slow query in JDBC  (Pavy Philippe <Philippe.Pavy@worldline.com>)
Список 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 по дате отправления:

Предыдущее
От: Subramaniam C
Дата:
Сообщение: Re: [PERFORM] Slow query in JDBC
Следующее
От: Pavy Philippe
Дата:
Сообщение: Re: [PERFORM] Slow query in JDBC