Sim Zacks <sim@xxxxxxxxxxxxxx> 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