Re: PostgreSQL backend process high memory usage issue

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.

Samuel

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