Skip site navigation (1) Skip section navigation (2)

Re: Prepared statements considered harmful

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: postgres hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Prepared statements considered harmful
Date: 2006-08-31 12:11:19
Message-ID: 1157026279.3033.22.camel@coppola.muc.ecircle.de (view raw or flat)
Thread:
Lists: pgsql-hackers
> - Redefine "prepared" to mean "parsed" rather than "parsed and planned".

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 ?

That would be immune both to statistics changes and parameter value
changes in certain limits. It would be also a lot more complex too than
a simple plan...

Cheers,
Csaba.





In response to

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2006-08-31 12:32:47
Subject: Re: Prepared statements considered harmful
Previous:From: Martijn van OosterhoutDate: 2006-08-31 12:09:09
Subject: Re: Prepared statements considered harmful

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group