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.