Re: functions and plans - Mailing list pgsql-general

From Tom Lane
Subject Re: functions and plans
Date
Msg-id 3236.1148392520@sss.pgh.pa.us
Whole thread Raw
In response to functions and plans  (Sim Zacks <sim@compulab.co.il>)
Responses Re: functions and plans  (Sim Zacks <sim@compulab.co.il>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: FUNCTION returns SETOF
Next
From: Sim Zacks
Date:
Subject: Re: functions and plans