Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tYRDV-00AqPY-Pi for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Jan 2025 14:51:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tYRDT-00EArC-Lj for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Jan 2025 14:51:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tYMCU-009TOd-B8 for pgsql-bugs@lists.postgresql.org; Thu, 16 Jan 2025 09:30:06 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tYMCT-000ggT-2G for pgsql-bugs@lists.postgresql.org; Thu, 16 Jan 2025 09:30:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=TMLxGaKdXzpN0ENdk2dUOFMZ4sFKi1sXnmKfRoIin/U=; b=3n2THEGn4XEz/d3LFRae7NAGwG EKOA8+LK+IPZbTEYcJghYC3n8+1x4Il5+ou6XG4YjaKkDIcVL7WtBxZ9pB8NisF/DtahXNt3hLSks HXlTivbRAOERhpxUp3NI/49r/F/gHmJXzGX/ZwzoughNIZPYFKVVi2YZGkHALOhjAx/ZURJ5ko9IQ vRCZzkyvLuZtw29DbjaHBv8tLYnkTCKXZsXgkggMWVuZJVWcXVFK768M2tBegNWhCTO4zOn4w8uX0 5ol2PobmagjgzTqfIEk96mdk1yNsYczczQmjk3dwkwntTZVL5JyPMnSuSzuQRJgZSGweI7RuXr83V pSs78xPQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tYMCS-005e1C-IQ for pgsql-bugs@lists.postgresql.org; Thu, 16 Jan 2025 09:30:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tYMCQ-00EMc3-ED for pgsql-bugs@lists.postgresql.org; Thu, 16 Jan 2025 09:30:02 +0000 Content-Type: multipart/mixed; boundary="===============7316059306333008130==" MIME-Version: 1.0 Subject: BUG #18775: PQgetCopyData always has an out-of-memory error if the table field stores bytea ~700 MB To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: knuazev@gmail.com Reply-To: knuazev@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 16 Jan 2025 09:29:17 +0000 Message-ID: <18775-e6af405ca08393cc@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7316059306333008130== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODc3NQpMb2dnZWQgYnk6ICAgICAgICAgIElseWEKRW1haWwgYWRkcmVz czogICAgICBrbnVhemV2QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE2LjAKT3BlcmF0 aW5nIHN5c3RlbTogICB3aW5kb3dzIDEwCkRlc2NyaXB0aW9uOiAgICAgICAgCgpIZWxsbywgSSBu ZWVkIHlvdXIgaGVscC4gVGhlIGVzc2VuY2Ugb2YgdGhlIHByb2JsZW0gaXMgdGhhdCBJIGFtIHRy eWluZyB0bwpkb3dubG9hZCBhIGJ5dGVhIGZpZWxkIGZyb20gYSB0YWJsZSByb3cuIFRoZSBzaXpl IG9mIHRoZSBkYXRhIGluIHRoZSBmaWVsZAppcyBhYm91dCA3MDAgTUIuIEluIHJlc3BvbnNlLCBJ IHJlY2VpdmUgYW4gb3V0LW9mLW1lbW9yeSBlcnJvci4NCg0KTW9yZSBkZXRhaWxzOg0KMSkgSSBl eGVjdXRlIHRoZSBxdWVyeQ0KQ09QWSAoU0VMRUNUICVzIEZST00gJXMuJXMgV0hFUkUgJXM9JXMp IFRPIFNURE9VVCBCSU5BUlkNCjIpIEkgY2FsbCB0aGUgUFFnZXRDb3B5RGF0YSBmdW5jdGlvbi4N Cg0KVGhpcyBmdW5jdGlvbiB3b3JrcyB3aXRoIHRoZSBwZ19jb25uLmluQnVmZmVyIGJ1ZmZlci4N CkkgZGlkIG5vdCBnbyBpbnRvIGRldGFpbCBvbiBob3cgbWVtb3J5IGlzIGFsbG9jYXRlZCBmb3Ig aXQsIGJ1dCBpbiBteSBjYXNlLAphYm91dCAzMDAgTUIgaXMgYWxsb2NhdGVkLiBBbmQgdGhlIGRh dGEgZnJvbSB0aGUgZGF0YWJhc2UgaXMgc3VjY2Vzc2Z1bGx5CmFjY3VtdWxhdGVkIGluIHRoaXMg YnVmZmVyLg0KDQpBbmQgd2hlbiB0aGUgYnVmZmVyIGlzIGFsbW9zdCBmdWxsLCB0aGUgZnVuY3Rp b24NCmludCBwcUdldENvcHlEYXRhMyhQR2Nvbm4gKmNvbm4sIGNoYXIgKipidWZmZXIsIGludCBh c3luYykNCnRyaWVzIHRvIGFsbG9jYXRlIGEgYnVmZmVyIGFsbW9zdCB0aGUgc2FtZSBzaXplIGFz IHBnX2Nvbm4uaW5CdWZmZXIgaW4gb3JkZXIKdG8gZ2l2ZSBpdCB0byB0aGUgdXNlcjoNCipidWZm ZXIgPSAoY2hhciAqKSBtYWxsb2MobXNnTGVuZ3RoICsgMSk7IChmZS1wcm90b3NvbC5jICBMTi4g MTc2NykuDQpJbiBteSBjYXNlLCB0aGUgbWFsbG9jIGZ1bmN0aW9uIGNvbnNpc3RlbnRseSBmYWls cyB0byBkbyB0aGlzLiBJdCByZXR1cm5zCk5VTEwgYW5kIHRoZSBsaWJyYXJ5IGdlbmVyYXRlcyBh biAib3V0IG9mIG1lbW9yeSIgZXJyb3IuDQoNCnAucy4NCg0KSXQgc2VlbXMgdG8gbWUgdGhhdCB0 aGUgb25seSBjaGFuY2UgdG8gbWFrZSBQUWdldENvcHlEYXRhIHdvcmsgY29ycmVjdGx5CndpdGhv dXQgY2hhbmdpbmcgdGhlIGxpYnJhcnkgaW50ZXJmYWNlIGlzIHRvIHNvbWVob3cgcmVkdWNlIHRo ZSBzaXplIG9mIHRoZQpwZ19jb25uLmluQnVmZmVyIGJ1ZmZlciB0byBzbWFsbCB2YWx1ZXMuDQoN CkFuZCBpZGVhbGx5LCBpdCB3b3VsZCBiZSBnb29kIHRvIGFkZCB0aGUgUFFnZXRDb3B5RGF0YTIg ZnVuY3Rpb24gdGhhdCB3b3VsZAphY2NlcHQgYSBidWZmZXIgYW5kIHNpbXBseSBmaWxsIGl0IHdp dGggZGF0YSBhbmQgcmV0dXJuIHRoZSBmaWxsaW5nIHNpemUuDQoNCkkgYWxzbyB0cmllZCB0byBn ZXQgYXJvdW5kIHRoaXMgcHJvYmxlbSB1c2luZyB0aGUgb3V0ZGF0ZWQgUFFnZXRsaW5lCmZ1bmN0 aW9uLCBidXQgaXQgZG9lcyBub3Qgd29yayB3aXRoIGJpbmFyeSBkYXRhLiBBbmQgaWYgeW91IG1h a2UgYSBDT1BZCihTRUxFQ1QgJXMgRlJPTSAlcy4lcyBXSEVSRSAlcz0lcykgVE8gU1RET1VUIHF1 ZXJ5LCBhbiBlcnJvciB3aWxsIG9jY3VyIHdoZW4KdHJ5aW5nIHRvIGV4ZWN1dGUgaXQuIEJlY2F1 c2UsIHBlcmhhcHMsIHRoZSBsaWJyYXJ5IGlzIHRyeWluZyB0byBkb3dubG9hZApldmVyeXRoaW5n IGF0IG9uY2UgaW50byBwZ19jb25uLmluQnVmZmVyLCB3aGljaCBpcyB0b28gc21hbGwgZm9yIHRo aXMuDQoNCkFuZCB5ZXMsIEkga25vdyB0aGF0IGZvciBzdG9yaW5nIGxhcmdlIGRhdGEgeW91IGhh dmUgImxhcmdlIG9iamVjdApmYWNpbGl0eSIuIEJ1dCBteSBtZXRob2Qgc2hvdWxkIGFsc28gd29y ayBmb3IgZmlsZXMgdXAgdG8gMSBHQi4KCg== --===============7316059306333008130==--