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.
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 |
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 |