Re: [PERFORM] Mysterious performance of query because of plsql function in

[CoL]

hi,

Peter Alberer wrote:

Hi there,

i have a problem with a query that uses the result of a plsql function
In
the where clause:

SELECT
   assignments.assignment_id,
   assignments.package_id AS package_id,
   assignments.title AS title,
   COUNT(*) AS Count
FROM
   assignments INNER JOIN submissions ON
   (assignments.assignment_id=submissions.assignment_id)
WHERE
   package_id=949589 AND
   submission_status(submissions.submission_id)='closed'
GROUP BY
   assignments.assignment_id, assignments.package_id, assignments.title
ORDER BY
   assignments.title;

Postgres seems to execute the function "submission_status" for every row
of
the submissions table (~1500 rows).

what is submission_status actualy?
\df submission_status
Is the function submission_status  called stable?

C.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings