Postgres Pro
Downloads
Home   >   mailing lists

Postmaster Crashing - Postgres 11 when JIT is enabled - Mailing list pgsql-bugs

From Mukesh Chhatani
Subject Postmaster Crashing - Postgres 11 when JIT is enabled
Date
Msg-id CACnmOY+PttqRpHKRVJwocDAjyd8Lt_9_78Af_Vk2pWJWFrVvQg@mail.gmail.com
Whole thread Raw
Responses Re: Postmaster Crashing - Postgres 11 when JIT is enabled  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view
Hello Team,

We are experiencing issues around Postmaster crashing due to cancellation of a simple query 

Postgres Version - 11.6
Environment - AWS RDS
Table Size - 50 GB

Few ways I resolved the issue :
1. Vacuum analyze the table and then execute the query and cancel it.
2. Disable JIT
3. Set max_parallel_workers_per_gather = 0

Attached is the file containing DEBUG logs and ERROR we are experiencing issues with.

Regards,
Mukesh
Attachment

pgsql-bugs by date:

Previous
From: Odin Ugedal
Date:
Subject: Re: [Bus error] huge_pages default value (try) not fall back
Next
From: Andres Freund
Date:
Subject: Re: Postmaster Crashing - Postgres 11 when JIT is enabled