Re: Re: Invalid memory alloc querying field type bytea

On 7/8/20 11:25 AM, Thompson, Shon wrote:
> Postgres returns the smaller rows without errors, but cannot return the two
> largest bytea fields.  The length function for the bytea data of these two
> rows returns:

> 647,034,150
> 819,319,303

>> "ERROR: XX000: invalid memory alloc request size 1294068297"


The problem is probably byteaout rendering the bytes as (presumably) hex, which
takes ~twice as many bytes as the data, and runs afoul of MaxAllocSize.

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development