On Fri, Apr 8, 2011 at 7:43 AM, Shianmiin <shianm...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general