Merlin Moncure-2 wrote: > > On Fri, Apr 8, 2011 at 2:00 PM, Shianmiin <Shianmiin@xxxxxxxxx> > wrote: >> Further clarification, >> >> if I run two concurrent threads >> >> pgbench memoryusagetest -c 2 -j 2 -T180 -f test.sql >> >> both backend processes uses 1.5GB and result in 3GB in total. > > yes. could you please post a capture of top after running the modified > test that does not run in single transaction. > > merlin > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > Here you are. http://postgresql.1045698.n5.nabble.com/file/n4292010/PostgreSQLBackendMemoryUsage.gif PostgreSQLBackendMemoryUsage.gif The screen shot was taken with running the following command pgbench memoryusagetest -c 2 -j 2 -T1800 -f test.sql I have to set the test time longer so that I got the chance to take the snapshot because if pgbench finishes, the connection will be gone. The snapshot was taken when I wait until the memory usage stable at 1.5GB. Please note in this tests, there are two PostgreSQL backend processes, each use 1.5GB of memory. Samuel -- View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-backend-process-high-memory-usage-issue-tp4289407p4292010.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
