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 BANLkTimoa0FGXtD0RCfJSwyH-aVV77MpOg@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
Re: PostgreSQL backend process high memory usage issue
List pgsql-general
On Fri, Apr 8, 2011 at 7:43 AM, Shianmiin <Shianmiin@gmail.com> wrote:
> Hi Merlin,
>
> I revised the test code with attached files and use pgbench to send the test
> queries.
>
> http://postgresql.1045698.n5.nabble.com/file/n4290723/dotest dotest
> http://postgresql.1045698.n5.nabble.com/file/n4290723/initialize.sql
> initialize.sql
> http://postgresql.1045698.n5.nabble.com/file/n4290723/test.sql test.sql

Not to beat on your test some more, but spamming count(*) is probably
not a good real world indicator of application performance (but it
might be).  I'm assuming your memory usage problem has gone away?

merlin

pgsql-general by date:

Previous
From: Shianmiin
Date:
Subject: Re: PostgreSQL backend process high memory usage issue
Next
From: Pavel Stehule
Date:
Subject: Re: cast list of oid