It depends what is the purpose of the function. If it's mainly a
container for a heap of SQL queries along with some simple IF, ELSE
etc. then I use two simple ways to analyze the performance (or lack
1) I use a lot of debug messages
2) I print out all SQL and the execute EXPLAIN / EXPLAIN ANALYZE on them
If the function is mainly a computation of something, it's usually nice
to try to use for example C language, as it's much faster than PL/pgSQL
for this type of functions.
But it depends on what you are trying to do in that function ...
> Is it possible to somehow analyze function performance? E.g.
> we are using function cleanup() which takes obviously too much time
> to execute but I have problems trying to figure what is slowing things
> When I explain analyze function lines step by step it show quite
> acceptable performance.
> PostgreSQL 8.0 is running on two dual core Opterons.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2006-06-15 14:24:04|
|Subject: Re: How to analyze function performance |
|Previous:||From: Mindaugas||Date: 2006-06-15 12:16:32|
|Subject: How to analyze function performance|