Le mercredi 16 mai 2018 à 09:48:54 UTC+2, ChatPristi <cchristo_0...@yahoo.fr> a écrit : Dear all,
I have a SELECT command (in partitionned tables) that failed with:psql:/tmp/query.txt:1: ERROR: out of memory DETAIL: Cannot enlarge string buffer containing 1073741818 bytes by 32 more bytes. I got the error with PG 10.3 and 10.4 on CentOS 7 up-to-date.The command works with a smaller size database. The command works with the same database with PG 9.3.19 on RHEL 6.9 up-to-date. I attach the EXPLAIN SELECT command. Apart rewriting the query is there any parameter that could be changed to make the query work in the postgresql.conf ? Thank you very much for any help. Hello, Any ideas where the OOM comes from in 10.4 while 9.3 is working ? Thanks.
