From: Chun Yit(Chronos) <ivanbeh@chronos.com.my>
To: pgsql-performance@postgresql.org
Subject: Postgresql7.4.5 running slow on plpgsql function
Date: Thu, 23 Jun 2005 17:56:52 +0800
Message-ID: <000601c577d9$e2658600$a279640a@Beh> (raw)
>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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ivanbeh@chronos.com.my
Subject: Re: Postgresql7.4.5 running slow on plpgsql function
In-Reply-To: <000601c577d9$e2658600$a279640a@Beh>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox