From: | Frits Jalvingh <jal(at)etc(dot)to> |
---|---|
To: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15225: [XX000] ERROR: invalid DSA memory alloc request size 1073741824 / Where: parallel worker |
Date: | 2018-06-06 17:13:29 |
Message-ID: | CAKhTGFWrW7++cvFbU8=pG6FeqwA0sEDK_sK0rmmo_ZDRf2kQQw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi Dilip,
That should not be possible; nothing else is using the DB on that machine
as it is my development machine.
On Wed, Jun 6, 2018 at 6:53 PM Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
> On Wed, Jun 6, 2018 at 3:45 PM, Frits Jalvingh <jal(at)etc(dot)to> wrote:
>
>> Hi Thomas,
>>
>> I know that the message is about running out of memory, I just meant to
>> say that it is a different message than before. Which led me to think that
>> this might be another issue. But of course OOM can occur at many places and
>> that might explain the different messages.
>>
>> As far as that explain thing goes, the odd thing seems to be that
>> /without/ the explain the database uses a non parallel plan. If I execute
>> the exact same statement without explain I see one postgres process running
>> at 100% for a long time, then it produces its output proper.
>>
>> If I add the explain part to it I see three processes: the main process
>> handling the EXPLAIN and two parallel workers. So the issue is that the
>> explain plan actually uses another plan than the same statement without
>> explain(!). This also explains the OOM, because indeed I see all processes
>> gobble up memory like mad, growing to 12GB each and then it dies.
>>
>
> There is also possiblility that it might have planned to use parallel
> worker (which is shown in explain )but during actual execution it has not
> got any free background worker (other parallel sessions might be using all
> the workers).
>
> --
> Regards,
> Dilip Kumar
> EnterpriseDB: http://www.enterprisedb.com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2018-06-06 18:52:52 | Re: BUG #15221: Could not open file "pg_subtrans/0013" |
Previous Message | Dilip Kumar | 2018-06-06 16:53:24 | Re: BUG #15225: [XX000] ERROR: invalid DSA memory alloc request size 1073741824 / Where: parallel worker |