Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERT statement going in IPC Wait_event - Mailing list pgsql-performance

From Samed YILDIRIM
Subject Re: INSERT statement going in IPC Wait_event
Date
Msg-id CAAo1mbkjjoSpX_ZgL_oEMY6Jxz9nQbq-7HFihv3rCu8RwGsU5w@mail.gmail.com
Whole thread Raw
In response to INSERT statement going in IPC Wait_event  (aditya desai <admad123@gmail.com>)
List pgsql-performance
Tree view
Hello Aditya,

How many connections do you have on your PostgreSQL cluster? And, do your webserver and database service run on the same machine/VM?

I would check system logs on the server on which PostgreSQL cluster run.

Best regards.
Samed YILDIRIM


On Wed, 1 Mar 2023 at 22:40, aditya desai <admad123@gmail.com> wrote:
Hi All,
Unfortunately I am unable to share a query  plan or query.

I have a SQL which is getting called from a web service. At a certain point where it inserts data in the table . Process is going in a hung state. pg_stat_activity shows wait_even='IPC' , wait_even_type=MessageQueueSend. In Webservice log we see I/O error occurred message.

Surprisingly when I run it from PSQL or pgadmin it runs fine. 

Has anyone come across this issue? Could you please help?

Regards,
Aditya.


pgsql-performance by date:

Previous
From: Samed YILDIRIM
Date:
Subject: Re: Planner choosing nested loop in place of Hashjoin
Next
From: André Rodrigues
Date:
Subject: Huge Tables