Postgres Pro
Downloads
Home   >   mailing lists

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

From Christophe combet
Subject Re: Out of memory error with PG10.3, 10.4 but not 9.3.19
Date
Msg-id 94578609.7479701.1528839797207@mail.yahoo.com
Whole thread Raw
In response to Out of memory error with PG10.3, 10.4 but not 9.3.19  (ChatPristi <cchristo_0899@yahoo.fr>)
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_upgrade 10.2
Next
From: Murthy Nunna
Date:
Subject: RE: pg_upgrade 10.2