| From: | ChatPristi <cchristo_0899(at)yahoo(dot)fr> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Out of memory error with PG10.3, 10.4 but not 9.3.19 |
| Date: | 2018-05-15 15:02:48 |
| Message-ID: | 2120893212.2682655.1526396569241@mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| Attachment | Content-Type | Size |
|---|---|---|
| explain.txt.zip | application/zip | 2.7 MB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2018-05-15 15:23:14 | Re: Control PhoneNumber Via SQL |
| Previous Message | Adrian Klaver | 2018-05-15 12:58:40 | Re: Function to set up variable inside it |