[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Backend memory leakage when inserting
From:       g.hintermayer () inode ! at (Gerhard Hintermayer)
Date:       2003-04-30 11:08:25
[Download RAW message or body]

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 ?

Gerhard


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[prev in list] [next in list] [prev in thread] [next in thread]