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

Поиск
Список
Период
Сортировка
От ChatPristi
Тема Out of memory error with PG10.3, 10.4 but not 9.3.19
Дата
Msg-id 2120893212.2682655.1526396569241@mail.yahoo.com
обсуждение исходный текст
Ответы Re: Out of memory error with PG10.3, 10.4 but not 9.3.19  (Michael Paquier <michael@paquier.xyz>)
Re: Out of memory error with PG10.3, 10.4 but not 9.3.19  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Re: Out of memory error with PG10.3, 10.4 but not 9.3.19  (Christophe combet <chrisc_pro@yahoo.fr>)
Список pgsql-general
Дерево обсуждения
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.



Вложения

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Function to set up variable inside it
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Control PhoneNumber Via SQL