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

From Hannu Krosing
Subject Re: Prepared statements considered harmful
Date
Msg-id 1157051473.3059.5.camel@localhost.localdomain
Whole thread Raw
In response to Re: Prepared statements considered harmful  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Ühel kenal päeval, N, 2006-08-31 kell 20:01, kirjutas Peter Eisentraut:

> For PL/pgSQL, you simply write a query and all the preparing action 
> happens implicitly.  There is nothing explicit about that interface.
>
> So if users have certain expectations here, they're just making them up.

Or basing them on experience.

I for one would not like it at all if all my queries (select * from
plpgsqlfunc()) just magically become slower by 10-50% 

If there will be an option not to plan/optimise prepared statemants, I
would certainly expect it to be off by default.

-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com




pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Prepared statements considered harmful
Next
From: "Victor B. Wagner"
Date:
Subject: Re: [PATCHES] Backend SSL configuration enhancement