Re: functions and plans

On Tue, May 23, 2006 at 04:19:56PM +0200, Sim Zacks wrote:
> I am trying to figure out some issues with my functions and I was hoping
> someone could help me.
> My understanding is that the plan is made when the function is run the
> first time. That means that running analyze on a table after a function
> is run once won't change the plan.
>
> 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.
>
> Any thoughts?

Best bet would probably be to turn on autovacuum. Short of that, setup a
cronjob.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461