| 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 13:33:17 |
| Message-ID: | BANLkTimoa0FGXtD0RCfJSwyH-aVV77MpOg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
On Fri, Apr 8, 2011 at 7:43 AM, Shianmiin <Shianmiin(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2011-04-08 14:41:43 | Re: Failed assert ((data - start) == data_size) in heaptuple.c |
| Previous Message | Shianmiin | 2011-04-08 12:43:07 | Re: PostgreSQL backend process high memory usage issue |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vick Khera | 2011-04-08 14:05:35 | Re: PostgreSQL + FreeBSD memory configuration, and an issue |
| Previous Message | Merlin Moncure | 2011-04-08 13:29:52 | Re: PostgreSQL + FreeBSD memory configuration, and an issue |