Re: Any way to *not* use server-side prepared statements in Postgresql? - Mailing list pgsql-jdbc

From Yang Zhang
Subject Re: Any way to *not* use server-side prepared statements in Postgresql?
Date
Msg-id CAKxBDU-AG-RTWWenN53xp0M88yx9oi0mBSdbaKMcJYDCSLjPRw@mail.gmail.com
Whole thread Raw
In response to Any way to *not* use server-side prepared statements in Postgresql?  (Yang Zhang <yanghatespam@gmail.com>)
List pgsql-jdbc
They're slower (by about 4x on our boxes) for cases where statements
are being generated beyond simple value parameters, such as trying
many distinct projections.

On Mon, Jul 18, 2011 at 7:47 PM, Maciek Sakrejda <msakrejda@truviso.com> wrote:
> It doesn't look like it. Any particular use case for this? The driver
> uses unnamed prepared statements here, and I'd be curious to hear
> where they are slower.
> ---
> Maciek Sakrejda | System Architect | Truviso
>
> 1065 E. Hillsdale Blvd., Suite 215
> Foster City, CA 94404
> (650) 242-3500 Main
> www.truviso.com
>



--
Yang Zhang
http://yz.mit.edu/

pgsql-jdbc by date:

Previous
From: Radosław Smogura
Date:
Subject: Re: Any way to *not* use server-side prepared statements in Postgresql?
Next
From: Oliver Jowett
Date:
Subject: Re: Any way to *not* use server-side prepared statements in Postgresql?