"Alexander M. Pravking" <[EMAIL PROTECTED]> writes:
> I've got a memory usage problem when I try to do a subselect on the same
> table as the main select (PostgreSQL 7.3.4 on FreeBSD). Here's my query:
> ...
> The "services" table is indexed only on "id" column and has about a
> thousand tuples. sreq(integer, text, timestamptz) is a strict immutable
> function written in SQL.
IIRC, there were intraquery memory leaks associated with SQL-language
functions until fairly recently. Can you try your problem case on 7.4?
Or see if you can rewrite the sreq function in plpgsql.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
