Re: Prepared statements considered harmful

[Peter Eisentraut <peter_e(at)gmx(dot)net>]

Am Donnerstag, 31. August 2006 14:11 schrieb Csaba Nagy:
> How about "prepared" means really "prepared"... in the sense of parsed,
> analyzed all sensible plans, and save a meta-plan which based on current
> statistics and parameter values chooses one of the considered (and
> cached) plans ?

I don't think this could solve one particularly frequent problem which is that 
pattern matching queries don't get along with prepared plans if the search 
pattern isn't known at planning time.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/