Stored Procedures Performance: Java vs. PL/Pgsql - Mailing list pgsql-general

From Daniel Kastenholz
Subject Stored Procedures Performance: Java vs. PL/Pgsql
Date
Msg-id 46528182.5060203@myTUM.de
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Siberia
Date:
Subject: dump/restore and statistics
Next
From: "Raymond C. Rodgers"
Date:
Subject: Inheritance question