On Thu, 2024-04-04 at 15:07 +0300, Naveen Kumar wrote: > 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.
Do you *always* see that wait event or only occasionally?
Occasional occurrences could be normal; in that case, it is probably the query that takes a long time.