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

Christophe combet <chrisc_pro@xxxxxxxx> · Tue, 12 Jun 2018 21:43:17 +0000 (UTC)

        Le mercredi 16 mai 2018 à 09:48:54 UTC+2, ChatPristi <cchristo_0899@xxxxxxxx> 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.