BUG #6365: Memory leak in insert and update
От | havasvolgyi.otto@gmail.com |
---|---|
Тема | BUG #6365: Memory leak in insert and update |
Дата | |
Msg-id | E1RgM1U-0002Z1-Em@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #6365: Memory leak in insert and update
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 6365 Logged by: Otto Havasv=C3=B6lgyi Email address: havasvolgyi.otto@gmail.com PostgreSQL version: 9.1.2 Operating system: Win XP SP2 x86; Linux Debian 2.6.32 kernel x64 Description:=20=20=20=20=20=20=20=20 The bug can be reproduced with pgbench: Insert script: \set nbranches 1*:scale \set ntellers 10*:scale \set naccounts 100000*:scale \setrandom aid 1 :naccounts \setrandom bid 1 :nbranches \setrandom tid 1 :ntellers \setrandom delta -5000 5000 insert into pgbench_history (tid, bid, aid, delta, mtime) values (:tid, :bid, :aid, :delta, current_timestamp); Update script: \set nbranches 1*:scale \set ntellers 10*:scale \set naccounts 100000*:scale \setrandom aid 1 :naccounts \setrandom bid 1 :nbranches \setrandom tid 1 :ntellers \setrandom delta -5000 5000 update pgbench_accounts set abalance =3D abalance + :delta where aid =3D :a= id; Steps: ./pgbench -i -Uotto test ./pgbench -c1 -j1 -T200 -Msimple -N -r -v -f insert.sql -Uotto testdb ./pgbench -c1 -j1 -T200 -Msimple -N -r -v -f update.sql -Uotto testdb During this test a continuous increase of the backend memory comsumption can be observed. During the insert test the increase is quite bigger than during update.
В списке pgsql-bugs по дате отправления: