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

Поиск

Список

Период

Сортировка

От	Christophe combet
Тема	Re: Out of memory error with PG10.3, 10.4 but not 9.3.19
Дата	13 июня 2018 г. 00:43:17
Msg-id	94578609.7479701.1528839797207@mail.yahoo.com обсуждение
Ответ на	Out of memory error with PG10.3, 10.4 but not 9.3.19 (ChatPristi <cchristo_0899@yahoo.fr>)
Список	pgsql-general

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

В списке pgsql-general по дате отправления: