Re: Prepared statements considered harmful - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Prepared statements considered harmful
Date
Msg-id 200608311432.48145.peter_e@gmx.net
Whole thread Raw
In response to Re: Prepared statements considered harmful  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: Prepared statements considered harmful
Re: Prepared statements considered harmful
List pgsql-hackers
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/


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: Prepared statements considered harmful
Next
From: Teodor Sigaev
Date:
Subject: Re: GIN FailedAssertions on Itanium2 with Intel compiler