Sim Zacks <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
