Very high memory utilization in Wondows 10 and Ubuntu with OBDBC Driver 13.1 and 13.2

From: Maurice Duvigneau <maurice(dot)duvigneau(at)pure-systems(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Cc: maurice(dot)duvigneau(at)pure-systems(dot)com
Subject: Very high memory utilization in Wondows 10 and Ubuntu with OBDBC Driver 13.1 and 13.2
Date: 2022-02-25 09:11:55
Message-ID: dfd5b175-0a81-3c78-545d-8fb35b9df397@pure-systems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,

we came across a problem with the PostgreSQL ODBC driver version 13.1
and 13.2.
It uses all available system memory, which is about 22GB on my system.

This problem occurred after updating from version 13.0 to 13.2 and can
also be reproduced with version 13.1.
The highest amount of used memory occurs during read operations on a
database which contains about 50 MB of data.
The version of the PostgreSQL database seem to be not of interest,
reproduced the problem with all version from13.0 up to 14.2.

We also found that the setting the following option solves that problem
in our case.

We would like to know if this is a bug introduced in 13.1 or if we do
something wrong.
If you need for information please get in touch with me.

Best regards,
Maurice Duvigneau

--
Maurice Duvigneau
Phone: +49-391-54456933 Fax: +49-391-54456990
--
pure-systems GmbH
Geschäftsführung: Danilo Beuche, Holger Papajewski
Sitz der Gesellschaft: Magdeburg
Registergericht: Amtsgericht Stendal, HRB 113044

Browse pgsql-odbc by date

  From Date Subject
Next Message Daniel Kempenich 2022-03-17 18:14:05 psqlodbc copy_and_convert_field "Unrecognized return value"
Previous Message Wal, Jan Tjalling van der 2022-02-15 09:31:13 psqlODBC x64 not respecting read-only parameter?