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

BUG #5515: Memory grows up problem

From: "Yuhui" <thesecularbird(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5515: Memory grows up problem
Date: 2010-06-21 11:40:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5515
Logged by:          Yuhui
Email address:      thesecularbird(at)hotmail(dot)com
PostgreSQL version: 8.3,8.2,8.1
Operating system:   Linux,Windows
Description:        Memory grows up problem

Do the follow setp to reproduce the problem:
CREATE TABLE mem_leak(A INT, B char(50) default 'abcdefg');
INSERT INTO mem_leak(a) VALUES(generate_series(1,200000000));

The memory which the execution process occupation will grows larger and
larger until all the memory is gone or the process is over or the process is
killed by the os.
If in create table statementthe "B char(50)" is changed to "B varchar(50)"
or delete the "default 'abcdefg'" the memory will not grow anymore.

The problem is not happen in the 8.4 above version.

pgsql-bugs by date

Next:From: YuhuiDate: 2010-06-21 11:41:51
Subject: BUG #5516: Memory grows up problem
Previous:From: Tatsuhito KasaharaDate: 2010-06-21 10:02:03
Subject: make_greater_string() does not return a string in some cases

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