Postgres Pro
Downloads
Home   >   mailing lists

Re: [JDBC] Query much slower when run from postgres function - Mailing list pgsql-performance

From Tom Lane
Subject Re: [JDBC] Query much slower when run from postgres function
Date
Msg-id 5165.1236618994@sss.pgh.pa.us
Whole thread Raw
In response to Re: [JDBC] Query much slower when run from postgres function  (Guillaume Smet <guillaume.smet@gmail.com>)
Responses Re: [JDBC] Query much slower when run from postgres function
Re: [JDBC] Query much slower when run from postgres function
List pgsql-performance
Tree view 
Guillaume Smet <guillaume.smet@gmail.com> writes:
> Unnamed prepared statements are planned after binding the values,
> starting with 8.3, or more precisely starting with 8.3.2 as early 8.3
> versions were partially broken on this behalf.

No, 8.2 did it too (otherwise we wouldn't have considered 8.3.0 to be
broken...).  The thing I'm not too clear about is what "use of an
unnamed statement" translates to for a JDBC user.

            regards, tom lane

pgsql-performance by date:

Previous
From: Guillaume Smet
Date:
Subject: Re: [JDBC] Query much slower when run from postgres function
Next
From: Andreas Wenk
Date:
Subject: Re: [JDBC] Query much slower when run from postgres function