a b
(cost=0.00..1496.89 rows=24174 width=45) (actual time=0.008..70.408 rows=24174
loops=1)"
"Total runtime: 372.765 ms"
Regards,
Sorin
-Ursprüngliche Nachricht-
Von: pgsql-performance-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] Im Auftrag
Hi,
I have the following function:
===
CREATE OR REPLACE FUNCTION xxx(text)
RETURNS SETOF v AS
$BODY$
select a.x, a.y,
CASE
WHEN strpos($1,b.x) > 0
THEN b.x
ELSE NULL
END AS mp_hm
from a LEFT JOIN b ON a.id=b.id
$BODY$
LAN
Hi,
I have some functions that select data from tables which are daily or monthly
updated. My functions are marked as STABLE. I am wondering if they perform
better if I mark they as IMMUTABLE?
Thank you,
Sorin
