Re: Slow statement when using JDBC

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: yazan suleiman <yazan(dot)suleiman(at)gmail(dot)com>
Cc: Maciek Sakrejda <msakrejda(at)truviso(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Slow statement when using JDBC
Date: 2011-02-02 23:20:15
Message-ID: 4765.1296688815@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

yazan suleiman <yazan(dot)suleiman(at)gmail(dot)com> writes:
> I've done more research. This problem appears at the database level. I
> excluded JDBC by running explain anaylze on 2 different statement, the first
> is a prepared one The prepared showed the same behavior. Please see below:

Try declaring the parameter the same type as the column it's being
compared to (which you didn't mention, but I'm guessing it's NUMERIC).

regards, tom lane

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Donald Fraser 2011-02-03 10:18:32 Re: Timing of notice delivery
Previous Message yazan suleiman 2011-02-02 22:11:20 Re: Slow statement when using JDBC