Skip site navigation (1) Skip section navigation (2)

Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: [PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set

From: Nikolas Everett <nik9000(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Kris Jurka <books(at)ejurka(dot)com>, Dave Crooke <dcrooke(at)gmail(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-jdbc(at)postgresql(dot)org, pgsql-performance <pgsql-performance(at)postgresql(dot)org>, Scott Carey <scott(at)richrelevance(dot)com>
Subject: Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: [PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
Date: 2010-04-21 15:43:52
Message-ID: u2jd4e11e981004210843ya970697dp8e3d88dec74577ca@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-performance
On Wed, Apr 21, 2010 at 11:30 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> >> On Tue, Apr 20, 2010 at 5:05 PM, Kris Jurka <books(at)ejurka(dot)com> wrote:
> >>> ... There are three ways to plan a PreparedStatement:
>
> FWIW, I think there is some consensus to experiment (in the 9.1 cycle)
> with making the server automatically try replanning of parameterized
> queries with the actual parameter values substituted.  It'll keep doing
> so if it finds that that produces a significantly better plan than the
> generic parameterized plan; which is what you'd expect if there's a
> chance to optimize a LIKE search, eliminate partitions, etc.
>
>                        regards, tom lane
>

That'd be wonderful.

In response to

pgsql-performance by date

Next:From: Kris JurkaDate: 2010-04-21 17:58:51
Subject: Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: [PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
Previous:From: nornDate: 2010-04-21 15:40:42
Subject: Re: significant slow down with various LIMIT

pgsql-jdbc by date

Next:From: Shivender DevarakondaDate: 2010-04-21 16:18:40
Subject: Re: Authentication failed when Password contains Japaneese Charecters
Previous:From: Tom LaneDate: 2010-04-21 15:30:26
Subject: Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: [PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group