Postgres Pro
Downloads
Home   >   mailing lists

Re: Create Materialized View from postgresql_fdw hang - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Create Materialized View from postgresql_fdw hang
Date
Msg-id cedd9bc4b8f02e84fb321dda448dc5480fe93115.camel@cybertec.at
Whole thread Raw
In response to [MASSMAIL]Create Materialized View from postgresql_fdw hang  (Naveen Kumar <naveenchowdaryon@gmail.com>)
Responses Re: Create Materialized View from postgresql_fdw hang
List pgsql-admin
Tree view 
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.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Naveen Kumar
Date:
Subject: [MASSMAIL]Create Materialized View from postgresql_fdw hang
Next
From: Naveen Kumar
Date:
Subject: Re: Create Materialized View from postgresql_fdw hang