Re: JDBC, prepared queries, and partitioning

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Stephen Denne <Stephen(dot)Denne(at)datamail(dot)co(dot)nz>
Cc: Kris Jurka <books(at)ejurka(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL - JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC, prepared queries, and partitioning
Date: 2008-02-13 21:55:56
Message-ID: 1202939756.16770.517.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 2008-02-14 at 10:45 +1300, Stephen Denne wrote:
> Simon Riggs wrote
> > ISTM we need a way to say "this query's parameters vary wildly at
> > execution time, so I really need to re-plan it every time".
>
> If the wild variations don't affect the cost estimate, they won't affect the plan?

Cost estimates are made at planning time. If you don't replan, no, they
won't.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Stephen Denne 2008-02-13 22:00:26 Re: JDBC, prepared queries, and partitioning
Previous Message Tom Lane 2008-02-13 21:50:38 Re: JDBC, prepared queries, and partitioning