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
