Re: PostgreSQL backend process high memory usage issue

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-08 21:27:04
Message-ID: BANLkTimwd389+f63Tztn5YcDRcsfsLYaww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Shianmiin 2011-04-08 22:07:43 Re: PostgreSQL backend process high memory usage issue
Previous Message Shianmiin 2011-04-08 19:00:42 Re: PostgreSQL backend process high memory usage issue

Browse pgsql-general by date

  From Date Subject
Next Message Clemens Eisserer 2011-04-08 21:44:21 Howto sort the result of UNION (without modifying its type)?
Previous Message Carlos Mennens 2011-04-08 20:11:37 Re: Changed SSL Certificates