Postgres Pro
Downloads
Home   >   mailing lists

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

From Subramaniam C
Subject [PERFORM] Slow query in JDBC
Date
Msg-id CAL=06W=f17ZnNQ8AdUKpd0p-6dfdwLios-Pvqkhqm7L8ziopjQ@mail.gmail.com
Whole thread Raw
Responses Re: [PERFORM] Slow query in JDBC  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Mike Broers
Date:
Subject: Re: [PERFORM] query of partitioned object doesnt use index in qa
Next
From: Julien Rouhaud
Date:
Subject: Re: [PERFORM] Slow query in JDBC