Re: PostgreSQL backend process high memory usage issue

Поиск
Список
Период
Сортировка
От Shianmiin
Тема Re: PostgreSQL backend process high memory usage issue
Дата
Msg-id 5079568567049855459@iso-8859-1msgid
обсуждение исходный текст
Ответ на Re: PostgreSQL backend process high memory usage issue  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Clemens Eisserer
Дата:
Сообщение: Howto sort the result of UNION (without modifying its type)?
Следующее
От: Shianmiin
Дата:
Сообщение: Re: PostgreSQL backend process high memory usage issue