Re: PostgreSQL backend process high memory usage issue

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]" <
ml-node+4290983-1196677718-196674(at)n5(dot)nabble(dot)com> wrote:

On Fri, Apr 8, 2011 at 7:43 AM, Shianmiin <[hidden
email]</user/SendEmail.jtp?type=node&node=4290983&i=0&by-user=t>>
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<http://postgresql.1045698.n5.nabble.com/file/n4290723/dotest?by-user=t> dotest

> http://postgresql.1045698.n5.nabble.com/file/n4290723/initialize.sql<http://postgresql.1045698.n5.nabble.com/file/n4290723/initialize.sql?by-user=t>
> initialize.sql
> http://postgresql.1045698.n5.nabble.com/file/n4290723/test.sql<http://postgresql.1045698.n5.nabble.com/file/n4290723/test.sql?by-user=t> 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]</user/SendEmail.jtp?type=node&node=4290983&i=1&by-user=t>)

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
To unsubscribe from PostgreSQL backend process high memory usage issue, click
here<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4289407&code=U2hpYW5taWluQGdtYWlsLmNvbXw0Mjg5NDA3fC0xMzg0MTAwNzE=>.

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