Fw: Re: Out of memory error with PG10.3, 10.4 but not 9.3.19

2018-06-06 Thread ChatPristi
Forgotten to CC the list, sorry... >Well, instead of an explain output which takes 2.4MB compressed and >9.6MB uncompressed (take it as unreadable), could you produce a >self-contained test case with a glimpse of the schema you are using? >Where does the OOM happen, and how did you change your pa

Fw: Re: Out of memory error with PG10.3, 10.4 but not 9.3.19

2018-06-06 Thread ChatPristi
Forgotten to CC the list too, sorry. again.. >1073741818 is a bit less than 1GB and 1073741818+32 is a bit more. So >you are obviously hitting a 1GB limit here. >Given that 1GB is the maximum length of a character type value in >PostgreSQL and the error message mentions a "string buffer", I sus