Slow query in JDBC

From: Subramaniam C <subramaniam31784(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Slow query in JDBC
Date: 2017-09-28 08:19:30
Message-ID: CAL=06W=f17ZnNQ8AdUKpd0p-6dfdwLios-Pvqkhqm7L8ziopjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi

When I try to execute the query from sql command line then that query is
taking only around 1 sec. But when I execute the query using JDBC(Java)
using preparedStatement then the same query is taking around 10 secs.

Can you please let us know the reason and how to fix this issue?

Thanks and Regards
Subramaniam

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Julien Rouhaud 2017-09-28 08:48:53 Re: Slow query in JDBC
Previous Message Mike Broers 2017-09-25 16:21:41 Re: query of partitioned object doesnt use index in qa