Re: PostgreSQL backend process high memory usage issue

From: Shianmiin <Shianmiin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL backend process high memory usage issue
Date: 2011-04-08 18:51:38
Message-ID: 1302288698332-4291691.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

No I didn't configured 1.5GB shared memory. For this test I recreated a
database cluster and leave everything in the configuration as default.

As in the original post,
when the connection was first established, the memory usage of backend
process showed in top was

VIRT = 182MB, RES = 6240K, SHR=4648K

while running

pgbench memoryusagetest -c 1 -j 1 -T180 -f test.sql

I saw the memory climb up rapidly to

VIRT = 1661MB RES = 1.5GB SHR = 55MB

once the tests is done, the process terminated and the memory returned to OS

Samuel

--
View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-backend-process-high-memory-usage-issue-tp4289407p4291691.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Shianmiin 2011-04-08 19:00:42 Re: PostgreSQL backend process high memory usage issue
Previous Message Merlin Moncure 2011-04-08 18:39:52 Re: PostgreSQL backend process high memory usage issue

Browse pgsql-general by date

  From Date Subject
Next Message Shianmiin 2011-04-08 19:00:42 Re: PostgreSQL backend process high memory usage issue
Previous Message Tom Lane 2011-04-08 18:45:08 Re: comma vs cross join question