Tom Lane wrote:
>
> darkcity@houston.rr.com (Val Ventura) writes:
> > I am new to PostgreSQL and I'm looking to port a MSSQL database. I am
> > currently working on the stored procedures, and I'm trying to
> > understand when and why I should choose SQL vs. PL/pgSQL vs. all the
> > others, as far as performance goes.
>
> For stuff that involves database accesses, plpgsql will almost always
> win, because it's the only one we have that caches query plans.
It's the only one that does the caching automatically. PL/Tcl has
separate commands for preparing and executing plans, and the programmer
has to put all the logic into his procedure.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #