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 D603452A06
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 11 Aug 2005 00:38:06 -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 30677-01
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 11 Aug 2005 03:37:58 +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 E376352A92
	for <pgsql-performance@postgresql.org>;
	Thu, 11 Aug 2005 00:37:54 -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 AA95752AD2
	for <pgsql-performance@postgresql.org>;
	Thu, 11 Aug 2005 11:37:51 +0800 (MYT)
Received: from Beh (unverified [203.106.54.162])
	by mail-std.fnbs.net.my (SurgeMail 3.0c2) with ESMTP id 17318585
	for <pgsql-performance@postgresql.org>;
	Thu, 11 Aug 2005 11:37:50 +0800 MYT
Message-ID: <002001c59e26$11bc5bf0$a279640a@Beh>
From: "Chun Yit(Chronos)" <ivanbeh@chronos.com.my>
To: <pgsql-performance@postgresql.org>
Subject: it is always delete temp table will slow down the postmaster?
Date: Thu, 11 Aug 2005 11:37:57 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_001D_01C59E69.1E7A1880"
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.079 tagged_above=0 required=5 tests=[AWL=-0.007,
	HTML_40_50=0.086, HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200508/106
X-Sequence-Number: 13853

This is a multi-part message in MIME format.

------=_NextPart_000_001D_01C59E69.1E7A1880
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: quoted-printable

>
>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=20
>searching function if i conitnue to run the server because old tuples =
are not really clear if just using delete command.
>so i use drop table command and recreate the table. my question is, =
would it slow down the postmaster speed if i continue to=20
>run this searching function more than 300 time per day?, cause the =
speed for execute searching function will graduatelly increase=20
>after i test it for few day? anyway to test it is causing by the drop =
temp table and create temp table command?
>
>regards
>ivan
------=_NextPart_000_001D_01C59E69.1E7A1880
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;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;hi, i got one situation here, i =
create one=20
pl/pgsql function that using temp table to store temporary =
data.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;wherever i execute my function, i =
need to=20
delete all the data inside the temp table, but this will slow down the=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;searching function if i conitnue to =
run the=20
server because old tuples are not really clear if just using delete=20
command.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;so i use drop table command and =
recreate the=20
table. my question is, would it slow down the postmaster speed if i =
continue to=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;run this searching function more =
than 300 time=20
per day?, cause the speed for execute searching function will =
graduatelly=20
increase </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;after i test it for few day? anyway =
to test it=20
is causing by the drop temp table and create temp table =
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_001D_01C59E69.1E7A1880--