From: | ChatPristi <cchristo_0899(at)yahoo(dot)fr> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Fw: Re: Out of memory error with PG10.3, 10.4 but not 9.3.19 |
Date: | 2018-06-06 20:30:18 |
Message-ID: | 606285219.2038704.1528317018514@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 suspect
>that your query tries to construct a very long string. Try to rewrite
>the query so that it creates several shorter strings instead.> hp
Peter,
Thank you for your answer.I understood tht some buffer limit is reached. But I do not see where.The output is 1513 rows and 78 kb.
--
_ | Peter J. Holzer | we build much bigger, better disasters now
|_|_) | | because we have much more sophisticated
| | | hjp(at)hjp(dot)at | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2018-06-06 20:45:48 | Re: Which backend using which pg_temp_N schema? |
Previous Message | Adrian Klaver | 2018-06-06 20:21:05 | Re: Slow planning time for simple query |