From: | Samed YILDIRIM <samed(at)reddoc(dot)net> |
---|---|
To: | aditya desai <admad123(at)gmail(dot)com> |
Cc: | Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
Subject: | Re: INSERT statement going in IPC Wait_event |
Date: | 2023-03-11 10:37:20 |
Message-ID: | CAAo1mbkjjoSpX_ZgL_oEMY6Jxz9nQbq-7HFihv3rCu8RwGsU5w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)gmail(dot)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.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | André Rodrigues | 2023-03-11 11:47:46 | Huge Tables |
Previous Message | Samed YILDIRIM | 2023-03-11 10:31:04 | Re: Planner choosing nested loop in place of Hashjoin |