| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | aditya desai <admad123(at)gmail(dot)com>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: INSERT statement going in IPC Wait_event |
| Date: | 2023-03-01 21:36:38 |
| Message-ID: | b3b0fe85-e163-af01-792f-3fabef0ff2f2@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Praneel Devisetty | 2023-03-07 12:14:08 | Planner choosing nested loop in place of Hashjoin |
| Previous Message | aditya desai | 2023-03-01 20:40:02 | INSERT statement going in IPC Wait_event |