"Alexander M. Pravking" <fduch(at)antar(dot)bryansk(dot)ru> 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