Re: JDBC, prepared queries, and partitioning - Mailing list pgsql-jdbc

From Simon Riggs
Subject Re: JDBC, prepared queries, and partitioning
Date
Msg-id 1202939756.16770.517.camel@ebony.site
Whole thread Raw
In response to Re: JDBC, prepared queries, and partitioning  ("Stephen Denne" <Stephen.Denne@datamail.co.nz>)
Responses Re: JDBC, prepared queries, and partitioning  ("Stephen Denne" <Stephen.Denne@datamail.co.nz>)
Re: JDBC, prepared queries, and partitioning  (Josh Berkus <josh@agliodbs.com>)
List 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


pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: JDBC, prepared queries, and partitioning
Next
From: "Stephen Denne"
Date:
Subject: Re: JDBC, prepared queries, and partitioning