MIME-Version: 1.0
In-Reply-To: 
 <CAOBaU_bDpYP-G0uA4Rbdv6DgToEGgkMvufftxxzAJWWcxoCKfg@mail.gmail.com>
References: 
 <CAL=06W=f17ZnNQ8AdUKpd0p-6dfdwLios-Pvqkhqm7L8ziopjQ@mail.gmail.com>
 <CAOBaU_bDpYP-G0uA4Rbdv6DgToEGgkMvufftxxzAJWWcxoCKfg@mail.gmail.com>
From: Subramaniam C <subramaniam31784@gmail.com>
Date: Thu, 28 Sep 2017 14:28:24 +0530
Message-ID: 
 <CAL=06Wme9NwYw9nDv034_DUJdzRxoDpK3r0v48-8fn-y=q+yyA@mail.gmail.com>
Subject: Re: Slow query in JDBC
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary="94eb2c0dc568648a61055a3c1c60"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--94eb2c0dc568648a61055a3c1c60
Content-Type: text/plain; charset="UTF-8"

I configured cursor_tuple_fraction to 1 but still I am facing the same
issue.
Please help.

On Thu, Sep 28, 2017 at 2:18 PM, Julien Rouhaud <rjuju123@gmail.com> wrote:

> On Thu, Sep 28, 2017 at 10:19 AM, Subramaniam C
> <subramaniam31784@gmail.com> wrote:
> > 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?
>
>
> I think jdbc always uses cursor, which can be problematic with default
> configuration, because postgres will try to generate plans that
> returns fast the first rows but not all the rows .  Can you try to
> configure cursor_tuple_fraction to 1 and see if that fixes your issue?
>

--94eb2c0dc568648a61055a3c1c60
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I configured=C2=A0<span style=3D"font-size:12.800000190734=
863px">cursor_tuple_fraction to 1 but still I am facing the same issue.</sp=
an><div><span style=3D"font-size:12.800000190734863px">Please help.</span><=
/div></div><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">On Thu=
, Sep 28, 2017 at 2:18 PM, Julien Rouhaud <span dir=3D"ltr">&lt;<a href=3D"=
mailto:rjuju123@gmail.com" target=3D"_blank">rjuju123@gmail.com</a>&gt;</sp=
an> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;=
border-left:1px #ccc solid;padding-left:1ex"><span class=3D"">On Thu, Sep 2=
8, 2017 at 10:19 AM, Subramaniam C<br>
&lt;<a href=3D"mailto:subramaniam31784@gmail.com">subramaniam31784@gmail.co=
m</a>&gt; wrote:<br>
&gt; Hi<br>
&gt;<br>
&gt; When I try to execute the query from sql command line then that query =
is<br>
&gt; taking only around 1 sec. But when I execute the query using JDBC(Java=
)<br>
&gt; using preparedStatement then the same query is taking around 10 secs.<=
br>
&gt;<br>
&gt; Can you please let us know the reason and how to fix this issue?<br>
<br>
<br>
</span>I think jdbc always uses cursor, which can be problematic with defau=
lt<br>
configuration, because postgres will try to generate plans that<br>
returns fast the first rows but not all the rows .=C2=A0 Can you try to<br>
configure cursor_tuple_fraction to 1 and see if that fixes your issue?<br>
</blockquote></div><br></div>

--94eb2c0dc568648a61055a3c1c60--