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

From Zeugswetter Andreas DCP SD
Subject Re: Prepared statements considered harmful
Date
Msg-id E1539E0ED7043848906A8FF995BDA579014DBEBE@m0143.s-mxs.net
Whole thread Raw
In response to Re: Prepared statements considered harmful  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
> Anyway, your plan assumes that you have information to work
> with. The current system plans prepared queries with no
> information at all about parameters and people are advocating
> to keep it that way. I think a good first step would be the
> plan on first execution, like Oracle does.

Yup, it is also possible to try to find an obvious plan and only
delay planning (or part of the plan) when different inputs make a
big difference (like MaxDB and Informix).

Andreas


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Prepared statements considered harmful
Next
From: Michael Glaesemann
Date:
Subject: Re: [PATCHES] Interval aggregate regression failure