Re: [HACKERS] Interesting results using new prepared statements

2002-09-17 Thread Bruce Momjian
Tom Lane wrote: > > But I am not > > sure how to find out what the execution plan is for a prepared > > statement, since EXPLAIN doesn't work for a prepared statement (i.e. > > EXPLAIN EXECUTE , doesn't work). > > Hmmm --- I can see the usefulness of that, but it looks like a new > feature and he

Re: [HACKERS] Interesting results using new prepared statements

2002-09-12 Thread Tom Lane
Barry Lind <[EMAIL PROTECTED]> writes: > ... I don't understand > why the timings for prepared statements would be less than for a regular > statement, and especially why using bind variables would be better than > without. I am concerned that prepared statements may be choosing a > different exe