Re: SQL Function Performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Adnan DURSUN" <a_dursun(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, mike(at)fuhr(dot)org
Subject: Re: SQL Function Performance
Date: 2006-02-14 00:57:07
Message-ID: 7000.1139878627@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Adnan DURSUN" <a_dursun(at)hotmail(dot)com> writes:
>>>> EXPLAIN ANALYZE EXECUTE stmt (...);

> Here is the EXPLAIN ANALYZE output for prepared statement :

This is exactly the same as the other plan --- you did not parameterize
the query. To see what's going on, you need to insert PREPARE
parameters in the places where the function uses plpgsql variables.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Fuhr 2006-02-14 01:31:54 Re: SQL Function Performance
Previous Message Adnan DURSUN 2006-02-14 00:16:49 Re: SQL Function Performance