Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1j8mFt-0001VS-0a for pgsql-interfaces@arkaria.postgresql.org; Mon, 02 Mar 2020 14:41:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j8mFr-0004bH-Fs for pgsql-interfaces@arkaria.postgresql.org; Mon, 02 Mar 2020 14:41:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j8mFr-0004b6-5d for pgsql-interfaces@lists.postgresql.org; Mon, 02 Mar 2020 14:41:11 +0000 Received: from mo6-p01-ob.smtp.rzone.de ([2a01:238:20a:202:5301::7]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j8mFn-0007Xc-3L for pgsql-interfaces@lists.postgresql.org; Mon, 02 Mar 2020 14:41:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; t=1583160066; s=strato-dkim-0002; d=zpmt.de; h=Message-ID:Date:Subject:In-Reply-To:References:To:From: X-RZG-CLASS-ID:X-RZG-AUTH:From:Subject:Sender; bh=6mf0lcRKlhjhKvfzWM3qveQp3O4JLT8v/Txtd9RIHA4=; b=mk8a8yxm34hItbWYgIYOWEn+9wYHYuyxUdFQcBdmCM/GlutwmJWfNRWiG0B5jGRjVP vx/hQ8y8ksES06E52Smiq/xe/tYpCZAfhMYkZfTNimmTQAHRQi+PJDmjzhtu8VADKaxk /ADENUfyn1iNY/819e82p2FAY8DZjp5as/k8jjSHOeW7mHUe8tCxerUkix7KF3el0Ifh 6QGdnhs2lUu7JZOigHdtfiT90zYLWEBQIG4OZCViQWRDwn9FNkJsQvlsZH+z0wPGs/t+ 9SJ+jI2lfJheYzk11ZnEiVFddm/2S23cc0mkmYhp2SQgx/12ucgQ5BYCt6sqGLDxRb5j 0Adw== X-RZG-AUTH: ":P3skb1Clb7FflLtjx7SyHqq9vvRtyij2FeY9PjvgVpE8mmdz07+nqRe9cAwvD3gi4Su8us1NAkL8Mh8sOPQiVf5HLNY=" X-RZG-CLASS-ID: mo00 Received: from SWHP2016 by smtp.strato.de (RZmta 46.2.0 AUTH) with ESMTPSA id V0ba32w22Ef57Mx (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256 bits)) (Client did not present a certificate) for ; Mon, 2 Mar 2020 15:41:05 +0100 (CET) From: "Stefan Wolf" To: References: In-Reply-To: Subject: MS-ACCESS 2010, ODBC 12.01, Out of Memory Date: Mon, 2 Mar 2020 15:41:05 +0100 Message-ID: <000e01d5f0a0$9aeec2f0$d0cc48d0$@zpmt.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000F_01D5F0A8.FCB3A020" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AdXwmqj1zTn1zrOLSMG7POwaKM0rfAABYSNw Content-Language: de List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_000F_01D5F0A8.FCB3A020 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Win10-Client: MS-ACCESS 2010 (32-Bit), ODBC-Driver: 12.01 Linux-Server (1): PostgreSQL 12.2 Linux-Server (2): PostgreSQL 9.6 We are currently migrating from PG 9.6. to 12.x. We've created System-DSNs (PostgreSQL Unicode) with [Defaults] for both Server. In MS-ACCESS our biggest Server-Tables (>14.000.000 Rows) can be opened (on both Servers). But it takes a lot of time and uses a lot of memory - more than 450MB on the client and some GB on the server. The indexes are recognized an filtering is fast. Trying to open more than one "big table" will result in MS-ACCESS "Out of memory". Best regards -Stefan Wolf- ------=_NextPart_000_000F_01D5F0A8.FCB3A020 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Win10-Client:=  MS-ACCESS 2010 (32-Bit),  ODBC-Driver: =  12.01

Linux-Server = (1):  PostgreSQL 12.2

Linux-Server = (2):  PostgreSQL  9.6

 

 

We are = currently migrating from PG 9.6. to = 12.x.

 

We’ve = created System-DSNs (PostgreSQL Unicode) with [Defaults] for both = Server.

 

In MS-ACCESS = our biggest Server-Tables (>14.000.000 Rows) can be opened (on both = Servers).

But it takes = a lot of time and uses a lot of memory - more than 450MB on the client and some GB on the = server.

 

The indexes = are recognized an filtering is fast.

 

Trying to = open more than one “big table” will result in MS-ACCESS = “Out of memory”.

 

Best = regards

-Stefan = Wolf-

 

------=_NextPart_000_000F_01D5F0A8.FCB3A020--