On Wed, Dec 31, 2008 at 11:01 AM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> wrote: >> The point of a prepared statement IMHO is to do the planning only once. >> There's necessarily a tradeoff between that and having a plan that's >> perfectly adapted to specific parameter values. > > I think it has been shown enough times that the performance drop caused > by a worse plan can be orders of magnitudes worse than what's gained by > producing the plan only once. It does not seem a bad idea to provide a > way to carry out only the parse phase, and postpone planning until the > parameters have been received. +1. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
