Skip site navigation (1) Skip section navigation (2)

Re: postmaster memory keep going up????

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Chun Yit(Chronos)" <ivanbeh(at)chronos(dot)com(dot)my>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postmaster memory keep going up????
Date: 2005-08-26 08:34:31
Message-ID: 430ED417.2050601@archonet.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-performance by date

Next:From: Arjen van der MeijdenDate: 2005-08-26 11:08:52
Subject: Inefficient queryplan for query with intersectable subselects/joins
Previous:From: Tobias BroxDate: 2005-08-26 06:20:51
Subject: Re: Limit + group + join

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group