From ivanbeh@chronos.com.my Fri Aug  26 06:08:43 2005
X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 5A222D6F75
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Aug 2005 03:08:43 -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 60615-09
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Aug 2005 06:08:41 +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 0AF9FD6E40
	for <pgsql-performance@postgresql.org>;
	Fri, 26 Aug 2005 03:08:39 -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 786E152AB7
	for <pgsql-performance@postgresql.org>;
	Fri, 26 Aug 2005 14:08:37 +0800 (MYT)
Received: from Beh (unverified [203.106.54.162])
	by mail-std.fnbs.net.my (SurgeMail 3.0c2) with ESMTP id 18087424
	for <pgsql-performance@postgresql.org>;
	Fri, 26 Aug 2005 14:08:37 +0800 MYT
Message-ID: <000b01c5aa04$a1ba0100$a279640a@Beh>
From: "Chun Yit(Chronos)" <ivanbeh@chronos.com.my>
To: <pgsql-performance@postgresql.org>
Subject: postmaster memory keep going up????
Date: Fri, 26 Aug 2005 14:08:51 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0008_01C5AA47.AF9CDCA0"
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.077 required=5 tests=[AWL=-0.019, HTML_50_60=0.095,
	HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200508/432
X-Sequence-Number: 14179

This is a multi-part message in MIME format.

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

>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 by getting out all the logic inside =
the function and what left only
>create temporary table and drop the temporary table statement (at the =
end if this function), i monitor the %mem for postmaster
>using linux command, ps -eo pid,comm,user,%mem | grep postmaster.
>when i start the postmaster, the %mem show only 2.0 something, but =
after i run the function for more that 1000 time, then
>the %mem will go up until 10.0 something.
>my question is,it is postmaster have memory leaking problem?
>hope someone can give me some help and best is how to identify the =
problem it is come from postgresql?
>
>thanks
>regards
>ivan
------=_NextPart_000_0008_01C5AA47.AF9CDCA0
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.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>&gt;I have a pl/pgsql function that =
using temp=20
table to perform searching logic,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;</FONT><FONT face=3DArial =
size=3D2>we have one=20
server running on 512MB, Red Hat 9.0, postgresql-7.4.5.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;the problem is the pl/pgsql =
function that i=20
created will increase postmaster memory when calling to =
function</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;become more frequent, i did a test =
by getting=20
out all the logic inside the function and what left only</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;create temporary table and drop the =
temporary=20
table statement (at the end if this function), i monitor the %mem for=20
postmaster</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;using linux command, ps -eo =
pid,comm,user,%mem=20
| grep postmaster.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;when i start the postmaster, the =
%mem show only=20
2.0 something, but after i run the function for more that 1000 time,=20
then</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;the %mem will go up until 10.0=20
something.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;my question is,it is postmaster =
have memory=20
leaking problem?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;hope someone can give me some help =
and best is=20
how to identify the problem it is come from postgresql?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&gt;thanks</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_0008_01C5AA47.AF9CDCA0--




From dev@archonet.com Fri Aug  26 08:35:35 2005
X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id C8D8ED7C5F
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Aug 2005 05:35:35 -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 03987-08
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Aug 2005 08:35:34 +0000 (GMT)
Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75])
	by svr1.postgresql.org (Postfix) with ESMTP id 124CFD7C70
	for <pgsql-performance@postgresql.org>;
	Fri, 26 Aug 2005 05:35:31 -0300 (ADT)
Received: from mainbox.archonet.com
	(84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99])
	by smtp.metronet.co.uk (MetroNet Mail) with ESMTP
	id 2A54B417C49; Fri, 26 Aug 2005 09:35:27 +0100 (BST)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mainbox.archonet.com (Postfix) with ESMTP id 45ABC15EDB;
	Fri, 26 Aug 2005 09:34:34 +0100 (BST)
Received: from mainbox.archonet.com ([127.0.0.1])
	by localhost (mainbox [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 31733-01; Fri, 26 Aug 2005 09:34:32 +0100 (BST)
Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP id E8FFE15ED9;
	Fri, 26 Aug 2005 09:34:31 +0100 (BST)
Message-ID: <430ED417.2050601@archonet.com>
Date: Fri, 26 Aug 2005 09:34:31 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: "Chun Yit(Chronos)" <ivanbeh@chronos.com.my>
Cc: pgsql-performance@postgresql.org
Subject: Re: postmaster memory keep going up????
References: <000b01c5aa04$a1ba0100$a279640a@Beh>
In-Reply-To: <000b01c5aa04$a1ba0100$a279640a@Beh>
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.057 required=5 tests=[AWL=0.007,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200508/434
X-Sequence-Number: 14181

Chun Yit(Chronos) wrote:
>>I have a pl/pgsql function that using temp table to perform searching logic,

>>my question is,it is postmaster have memory leaking problem?

First step - upgrade to the latest 7.4.x release.

Second step - read the "release notes" section of the manuals for 7.4.x
and 8.0.x and see what it says about memory and plpgsql.

--
  Richard Huxton
  Archonet Ltd