From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Shianmiin <Shianmiin(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL backend process high memory usage issue |
Date: | 2011-04-12 13:57:45 |
Message-ID: | BANLkTinPOBAV+Cjuc0q5GduiLmqQzA=Hpw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general |
On Fri, Apr 8, 2011 at 5:07 PM, Shianmiin <Shianmiin(at)gmail(dot)com> wrote:
>
> Merlin Moncure-2 wrote:
>>
>> On Fri, Apr 8, 2011 at 2:00 PM, Shianmiin <Shianmiin(at)gmail(dot)com>
>> wrote:
>>> Further clarification,
>>>
>>> if I run two concurrent threads
>>>
>>> pgbench memoryusagetest -c 2 -j 2 -T180 -f test.sql
>>>
>>> both backend processes uses 1.5GB and result in 3GB in total.
>>
>> yes. could you please post a capture of top after running the modified
>> test that does not run in single transaction.
>>
>> merlin
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
> Here you are.
>
> http://postgresql.1045698.n5.nabble.com/file/n4292010/PostgreSQLBackendMemoryUsage.gif
> PostgreSQLBackendMemoryUsage.gif
>
> The screen shot was taken with running the following command
>
> pgbench memoryusagetest -c 2 -j 2 -T1800 -f test.sql
>
> I have to set the test time longer so that I got the chance to take the
> snapshot because if pgbench finishes, the connection will be gone.
>
> The snapshot was taken when I wait until the memory usage stable at 1.5GB.
>
> Please note in this tests, there are two PostgreSQL backend processes, each
> use 1.5GB of memory.
I am not seeing your results. I was able to run your test on a stock
config (cut down to 50 schemas though) on a vm with 512mb of memory.
What is your shared buffers set to?
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Cocei | 2011-04-12 14:13:13 | Re: BUG #5972: Update with subquery: erroneous results for foreign key field |
Previous Message | Kevin Grittner | 2011-04-12 13:42:00 | Re: BUG #5972: Update with subquery: erroneous results for foreign key field |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-04-12 14:29:44 | Re: Different cast behavior of TEXT and VARCHAR |
Previous Message | Merlin Moncure | 2011-04-12 13:34:42 | Re: Why is 8.4 and 9.0 so much slower on some queries? |