X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D12A652968
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Jun 2005 06:57:11 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 00513-01
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Jun 2005 09:57:08 +0000 (GMT)
Received: from smtp-gw.fnbs.net.my (smtp-gw.fnbs.net.my [202.9.108.191])
	by svr1.postgresql.org (Postfix) with ESMTP id C6FDE528C7
	for <pgsql-performance@postgresql.org>;
	Thu, 23 Jun 2005 06:57:03 -0300 (ADT)
Received: from mail-std.fnbs.net.my (smtp-std.fnbs.net.my [202.9.108.197])
	by fnsrvlx9.fnbs.net.my (SMTP Mailer) with ESMTP id B3F5A529FF
	for <pgsql-performance@postgresql.org>;
	Thu, 23 Jun 2005 17:57:03 +0800 (MYT)
Received: from Beh (unverified [203.106.54.162])
	by mail-std.fnbs.net.my (SurgeMail 3.0c2) with ESMTP id 14657212
	for <pgsql-performance@postgresql.org>;
	Thu, 23 Jun 2005 17:57:02 +0800 MYT
Message-ID: <000601c577d9$e2658600$a279640a@Beh>
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
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0003_01C5781C.EF90D170"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.096 tagged_above=0 required=5 tests=HTML_50_60,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200506/531
X-Sequence-Number: 13168

This is a multi-part message in MIME format.

------=_NextPart_000_0003_01C5781C.EF90D170
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: quoted-printable

>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
------=_NextPart_000_0003_01C5781C.EF90D170
Content-Type: text/html;
	charset="gb2312"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dgb2312">
<META content=3D"MSHTML 6.00.2900.2668" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>&gt;hi, need some help with some =
experts=20
here.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;currently we have a function that =
use together=20
with temp table, it calls search result function, everytime</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;this function is calling, it will =
go through=20
some filter before come out as a result.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;now we have some major problem , =
the first time=20
the function execute, it take about 13 second</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;second time the function is =
execute, it take=20
about 17 second, every time you execute the function</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;the time taken will grow about 4 =
second,=20
?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;may&nbsp;i know what going on=20
here?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;since we use function with temp =
table, so every=20
statement that related to temp table will using EXECUTE</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;command.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;ivan</FONT></DIV></BODY></HTML>

------=_NextPart_000_0003_01C5781C.EF90D170--