Re: speed of server side languages

Val Ventura wrote:
> 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.
>
> Is there a document that addresses when to use what, if compatibility
> is not an issue? I would probably be rewriting the gist of the stored
> procedures, instead of trying to port them line by line, so I don't
> care how different it is from T/SQL.
>
> My searches turned up nothing yet... I've seen the question asked a
> few times, but google ate the replies (if any).

PL/pgSQL is probably the fastest because it gets compiled on first
execution.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073