Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow statement when using JDBC - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Slow statement when using JDBC
Date
Msg-id 4765.1296688815@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow statement when using JDBC  (yazan suleiman <yazan.suleiman@gmail.com>)
List pgsql-jdbc
Tree view 
yazan suleiman <yazan.suleiman@gmail.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

pgsql-jdbc by date:

Previous
From: yazan suleiman
Date:
Subject: Re: Slow statement when using JDBC
Next
From: "Donald Fraser"
Date:
Subject: Re: Timing of notice delivery