"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