| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc pgsql-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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shivender Devarakonda | 2010-04-21 16:18:40 | Re: Authentication failed when Password contains Japaneese Charecters |
| Previous Message | Tom Lane | 2010-04-21 15:30:26 | 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 | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2010-04-21 17:58:51 | 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 Message | norn | 2010-04-21 15:40:42 | Re: significant slow down with various LIMIT |