>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 function execute, it take about 13 second
>second time the function is execute, it take
about 17 second, every time you execute the function
>the time taken will grow about 4 second,
?
>may i know what going on
here?
>since we use function with temp table, so every
statement that related to temp table will using EXECUTE
>command.
>
>regards
>ivan
|
- [PERFORM] Postgresql7.4.5 running slow on plpgsql functi... Chun Yit(Chronos)
- Re: [PERFORM] Postgresql7.4.5 running slow on plpgs... Michael Fuhr
- Re: [PERFORM] Postgresql7.4.5 running slow on p... Michael Fuhr