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
Message-ID: <000b01c5aa04$a1ba0100$a279640a@Beh> (raw)
>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
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: postmaster memory keep going up????
In-Reply-To: <000b01c5aa04$a1ba0100$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