Create Materialized View from postgresql_fdw hang

From: Naveen Kumar <naveenchowdaryon(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Create Materialized View from postgresql_fdw hang
Date: 2024-04-04 12:07:42
Message-ID: CADk76jpVFzaNFwc6oxfJO8wfVR-2XtRskmrNNkyPEWy3i21iJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

I am trying to create a materialized view with postgresql_fdw, and
it hangs for hours. In pg_stat_activity I am seeing wait_event_type
and wait_event Extension.
In the source server, the state is "idle in transaction" and the query is
"FETCH 100 FROM c1". Any suggestions on how to speed this up?

Thanks & Regards,
Naveen Kumar .M,
Sr. PostgreSQL Database Administrator,
Mobile: 7755929449.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-04-04 17:52:04 Re: Create Materialized View from postgresql_fdw hang
Previous Message Samed YILDIRIM 2024-04-04 10:59:03 Re: Postgresql - Pgbouncer Connection and Query Performance Problem