Re: functions and plans
Sim Zacks <sim@compulab.co.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
Import Notes
Reply to msg id not found: e4v29u$1ehh$1@news.hub.orgReference msg id not found: e4v29u$1ehh$1@news.hub.org
Truncate won't work for me because I don't completely empty the table, I
just empty it for that user.
Each user has the table populated with his data, basically to work like
a temporary table. When the user runs a function it repopulates his
working table and then until he runs the function again he has that
dataset to work with. (I just noticed I wrote select and delete,
actually it deletes and then selects)
Tom Lane wrote:
Show quoted text
Sim Zacks <sim@compulab.co.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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?