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

Re: Backend memory leakage when inserting

From: g(dot)hintermayer(at)inode(dot)at (Gerhard Hintermayer)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Backend memory leakage when inserting
Date: 2003-04-30 11:08:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Should have investigated this better before posting:

I have the following test case:
PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.95.2 (running
a 2.2.23 kernel)
create an empty database
create table testdb(i integer,t timestamp);

edit a file fill.sql with 500 identical lines:
INSERT INTO testdb VALUES(1,'now()');

check memory of backend process (ps axuw): Column RSS 3224
\i fill.sql
backend RSS 3295 (ok, some sort of basic mem probably)
\i fill.sql ~ 10 times
backend RSS 3300
\i fill.sql ~ 25 times
backend RSS 3304
\i fill.sql ~ 70 times
backend RSS 3316

VSZ value is always the same (6248). So what's going on here ?

(now i have ~ 53500 tuples in my table)

I have no idea, what's going on here ? Any ideas ?


In response to


pgsql-general by date

Next:From: Tom LaneDate: 2003-04-30 14:30:14
Subject: Re: pg_dumpall -g problem
Previous:From: David GoodenoughDate: 2003-04-30 10:55:10
Subject: pg_dumpall -g problem

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