pgsql-bugs(at)postgresql(dot)org writes:
> memory leak while using cursors
> DECLARE BOB CURSOR FOR select date_part('epoch', call_time), date_part('hour', call_time), date_part('minute', call_time), date_part('dow', call_time), * from call_jan where call_time >= '2000/12/16 00:00:00.000' and call_time < '2001/01/21 00:00:00.000' FOR READ ONLY;
The date_part function calls will each leak a few bytes of memory that
doesn't get reclaimed till end of query (= cursor close, in this case).
This is fixed for 7.1 but there's no fix for older versions.
regards, tom lane