Re: PostgreSQL backend process high memory usage issue - Mailing list pgsql-general

From Merlin Moncure
Subject Re: PostgreSQL backend process high memory usage issue
Date
Msg-id BANLkTimwd389+f63Tztn5YcDRcsfsLYaww@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL backend process high memory usage issue  (Shianmiin <Shianmiin@gmail.com>)
Responses Re: PostgreSQL backend process high memory usage issue
List pgsql-general
On Fri, Apr 8, 2011 at 2:00 PM, Shianmiin <Shianmiin@gmail.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

pgsql-general by date:

Previous
From: Shianmiin
Date:
Subject: Re: PostgreSQL backend process high memory usage issue
Next
From: Clemens Eisserer
Date:
Subject: Howto sort the result of UNION (without modifying its type)?