Postgres Pro
Downloads
Home   >   mailing lists

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

From Shianmiin
Subject Re: PostgreSQL backend process high memory usage issue
Date
Msg-id 5079568567049855459@iso-8859-1msgid
Whole thread Raw
In response to Re: PostgreSQL backend process high memory usage issue  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view
No. The highmemory usage issueis stll there.

We could change select count(*) to select * or select 1 if you like. Therre is no data in the tables anyway.

Sent from my iPad

On 2011-04-08, at 8:25 AM, "Merlin Moncure-2 [via PostgreSQL]" <[hidden email]> wrote:

On Fri, Apr 8, 2011 at 7:43 AM, Shianmiin <[hidden email]> 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

--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-backend-process-high-memory-usage-issue-tp4289407p4290983.html

View this message in context: Re: PostgreSQL backend process high memory usage issue
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

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