Re: Is it a memory leak in PostgreSQL 7.4beta?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is it a memory leak in PostgreSQL 7.4beta?
Дата
Msg-id 6351.1062282948@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Is it a memory leak in PostgreSQL 7.4beta?  (Hans-Jürgen Schönig <hs@cybertec.at>)
Ответы Re: Is it a memory leak in PostgreSQL 7.4beta?  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: Is it a memory leak in PostgreSQL 7.4beta?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Hans-Jürgen Schönig <hs@cybertec.at> writes:
> The interesting thing was that my postmaster needed around 4mb of RAM 
> when I started running my test script using ...
> After about 2 1/2 hours the backend process already needed 11mb of ram. 

Hmm.  I tried

create table t_data (data int4, ts timestamp default now());

followed by many repetitions of

START TRANSACTION ISOLATION LEVEL READ COMMITTED;
INSERT INTO t_data (data) VALUES ('2500');
UPDATE t_data SET data = '2500' WHERE data = '2500';
DELETE FROM t_data WHERE data = '2500';
COMMIT;

I am seeing a slow but steady growth of the backend process on a Linux
box (RHL 8.0) --- top shows it growing a few K every few seconds.

But I see *zero* growth with the same test on HPUX 10.20.

A possible wild card is that the Postgres build I'm using on the Linux
box is compiled for profiling (-pg, no --enable-debug or --enable-cassert)
whereas the HPUX build has --enable-debug and --enable-cassert but no
profiling.  I'm not aware that there's any known memory leakage in
Linux' profiling support, though.

Can anyone else reproduce this, or confirm they don't see it?  What
platform, and what configure options?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: ALTER TABLE ... TO ... to change related names
Следующее
От: Dennis Björklund
Дата:
Сообщение: Re: ALTER TABLE ... TO ... to change related names