On 08/07/2016 14:11, AMatveev@xxxxxxxx wrote:
Hi. We have tested postgreSql,Oracle,MSSqlServer. The test performs about 11K lines of code Memory usage per session: Oracle: about 5M MSSqlServer: about 4M postgreSql: about 160М The result of postgreSql is very sad(Our typical business logic has about 30K lines of code). How can I reduce memory consumption per session? Note, we cant move the business logic to an application server as it will lead us to performance problem. I can send the test script on request. Test description: PostgreSQL 9.5.3, compiled by Visual C build 1800, 64-bit
Visual C??? You will have to run PostgreSQL on a proper Unix system to test for performance.
At the same time we run 50 sessions that perform the following functions: CREATE OR REPLACE FUNCTION perfa.func9 ... BEGIN svSql:=''; PERFORM perfb."func91"(); ... END; CREATE OR REPLACE FUNCTION perfb.func91 ... BEGIN PERFORM perfc."func911"(); ... END; CREATE OR REPLACE FUNCTION perfc.func911 ( ) RETURNS void AS $body$ DECLARE svSql BIGINT; BEGIN svSql:=0; ... svSql:=svSql+10; END; $body$
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
