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 ; 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 ; 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 ; 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 ; 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 ; Fri, 26 Aug 2005 14:08:37 +0800 MYT Message-ID: <000b01c5aa04$a1ba0100$a279640a@Beh> From: "Chun Yit(Chronos)" To: 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
>I have a pl/pgsql function that = using temp=20 table to perform searching logic,
>we have one=20 server running on 512MB, Red Hat 9.0, postgresql-7.4.5.
>the problem is the pl/pgsql = function that i=20 created will increase postmaster memory when calling to = function
>become more frequent, i did a test = by getting=20 out all the logic inside the function and what left only
>create temporary table and drop the = temporary=20 table statement (at the end if this function), i monitor the %mem for=20 postmaster
>using linux command, ps -eo = pid,comm,user,%mem=20 | grep postmaster.
>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
>the %mem will go up until 10.0=20 something.
>my question is,it is postmaster = have memory=20 leaking problem?
>hope someone can give me some help = and best is=20 how to identify the problem it is come from postgresql?
>
>thanks
>regards
>ivan
------=_NextPart_000_0008_01C5AA47.AF9CDCA0--