pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpostmaster memory keep going up????
2+ messages / 2 participants
[nested] [flat]
* postmaster memory keep going up????
@ 2005-08-26 06:08 Chun Yit(Chronos) <ivanbeh@chronos.com.my>
0 siblings, 1 reply; 2+ messages in thread
From: Chun Yit(Chronos) @ 2005-08-26 06:08 UTC (permalink / raw)
To: pgsql-performance
>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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: postmaster memory keep going up????
@ 2005-08-26 08:34 Richard Huxton <dev@archonet.com>
parent: Chun Yit(Chronos) <ivanbeh@chronos.com.my>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Huxton @ 2005-08-26 08:34 UTC (permalink / raw)
To: Chun Yit(Chronos) <ivanbeh@chronos.com.my>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-08-26 08:34 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-26 06:08 postmaster memory keep going up???? Chun Yit(Chronos) <ivanbeh@chronos.com.my>
2005-08-26 08:34 ` Richard Huxton <dev@archonet.com>
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