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