On 08/07/2016 14:11, amatv...@bitec.ru 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
