"Ian Harding" <[EMAIL PROTECTED]> writes: > It is pltcl [not plpgsql]
Ah. I don't think we've done much of any work on plugging leaks in pltcl :-(. > It hurts when I do this: > drop function memleak(); > create function memleak() returns int as ' > for {set counter 1} {$counter < 100000} {incr counter} { > set sql "select ''foo''" > spi_exec "$sql" > } > ' language 'pltcl'; > select memleak(); Yeah, I see very quick memory exhaustion also :-(. Looks like the spi_exec call is the culprit, but I'm not sure exactly why ... anyone have time to look at this? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])