2
votes
0answers
28 views

Why does returning a custom data type appear to cause a memory leak in my PL/Perl stored procedure?

I have recently encountered what appears to be a memory leak with a particular long-running postgres process, which runs a stored procedure. I am able to reproduce the same behavior with a very ...
3
votes
1answer
491 views

PostgreSQL pl/perl trigger, differentiate null vs empty

I've been trying to speed up a generic auditing trigger that I had written in pl/pgsql some time back. On update, it generates a list of columns in the table being updated and inserts rows in the ...