>hi, need some help with some experts
here.
>currently we have a function that use together
with temp table, it calls search result function, everytime
>this function is calling, it will go through
some filter before come out as a result.
>now we have some major problem , the first time
the
>
>hi, i got one situation here, i create one
pl/pgsql function that using temp table to store temporary data.
>wherever i execute my function, i need to
delete all the data inside the temp table, but this will slow down the
>searching function if i conitnue to run the
server because old tu
- Original Message -
From: "Qingqing Zhou" <[EMAIL PROTECTED]>
To:
Sent: Thursday, August 11, 2005 2:37 PM
Subject: Re: [PERFORM] it is always delete temp table will slow down the
postmaster?
""Chun Yit(Chronos)"" <[EMAIL PROTECTED]>
>I have a pl/pgsql function that using temp
table to perform searching logic,
>we have one
server running on 512MB, Red Hat 9.0, postgresql-7.4.5.
>the problem is the pl/pgsql function that i
created will increase postmaster memory when calling to function
>become more frequent, i did a test
