Tzahi Fadida <tzahi_ml(at)myrealbox(dot)com> writes:
> I am writing C functions and I use SPI extensively.
> Till now I used cursors and there was no memory leaks.
> But now I do thousands of inserts using SPI_execp
> and I also give it parameters.
If SPI_execp leaked memory then so would almost any plpgsql function,
so I'm inclined to think the leak is in your own code. Post a complete
example if you want it investigated.
regards, tom lane