Home > mailing lists

Out of memory error with PG10.3, 10.4 but not 9.3.19 - Mailing list pgsql-general

From	ChatPristi
Subject	Out of memory error with PG10.3, 10.4 but not 9.3.19
Date	May 15, 2018 21:02:48
Msg-id	2120893212.2682655.1526396569241@mail.yahoo.com Whole thread Raw
Responses	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>)
List	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.

From: Adrian Klaver
Date: 15 May 2018, 18:58:40
Subject: Re: Function to set up variable inside it

From: Alvaro Herrera
Date: 15 May 2018, 21:23:14
Subject: Re: Control PhoneNumber Via SQL