Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Dunstan
Subject Re: INSERT statement going in IPC Wait_event
Date
Msg-id b3b0fe85-e163-af01-792f-3fabef0ff2f2@dunslane.net
Whole thread Raw
In response to INSERT statement going in IPC Wait_event  (aditya desai <admad123@gmail.com>)
List pgsql-performance
Tree view


On 2023-03-01 We 15:40, aditya desai 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. 



Doesn't this suggest that the problem is probably not with Postgres but with your web service (about which you have given us no information whatsoever)?


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

pgsql-performance by date:

Previous
From: aditya desai
Date:
Subject: INSERT statement going in IPC Wait_event
Next
From: Praneel Devisetty
Date:
Subject: Planner choosing nested loop in place of Hashjoin