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
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 agai
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,
