Stored Procedures Performance: Java vs. PL/Pgsql

From: Daniel Kastenholz <Daniel(dot)Kastenholz(at)myTUM(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Stored Procedures Performance: Java vs. PL/Pgsql
Date: 2007-05-22 05:37:06
Message-ID: 46528182.5060203@myTUM.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

is there a rule of thumb or an estimate which language provides the best
performance for stored procedures?

I'm currently using PL/Pgsql, and wondering
- to what extent these stored procedures are actually precompiled and/or
optimized
- if Java might provide better performance, or if parameter
transformation and VM calls eat up the performance gains (if any)

I'm aware that these questions can't be answered in a "universally
valid" fashion, but I would appreciate your experiences.

Thanks.

Daniel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2007-05-22 06:25:15 Re: Lock table, Select for update and Serialization error
Previous Message Dave Page 2007-05-22 03:24:56 Re: What is "Postgresql Hot"?