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.
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.
<<attachment: explain.txt.zip>>
