Backend memory leakage when inserting

From: g(dot)hintermayer(at)inode(dot)at (Gerhard Hintermayer)
To: pgsql-general(at)postgresql(dot)org
Subject: Backend memory leakage when inserting
Date: 2003-04-29 07:26:10
Message-ID: bd4db85f.0304282326.1dcd6a16@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm currently using 7.3.1 (linux 2.2.17) and noticed a memory leakage
in the backend when I do lots of inserts. I tried psql (insert into a
table with timstamps, values: 'now()') and with libpgtcl (the patched
version, that comes along with 7.3.2) and always noticed a memory
leakage. A process, that was running for 2 month doing about ~ 200
inserts/hour resulted in a backend that consumed ~ 120MB of memory.
Has anyone encountered this problem and if yes, has this been fixed in
7.3.2 ? I don't want to upgrade, unless I can be sure this is fixed,
as this is the only problem I have and the inserting process could be
redesigned to close/open the connection after some days.

Gerhard Hintermayer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Antti Haapala 2003-04-29 07:52:41 Re: timestamps and dates
Previous Message Ron Johnson 2003-04-29 06:01:39 Re: > 16TB worth of data question