Sim Zacks <sim(at)compulab(dot)co(dot)il> writes:
> I have a table that I populate, select and delete the data each time the
> function is run. Each time I run the function it takes longer to get the
> data. In these tests, the data is the exact same every time.
> I tried putting vacuum inside the function, but I got an error, cannot
> run vacuum inside of function.
TRUNCATE, maybe?
regards, tom lane