Re: Create Materialized View from postgresql_fdw hang

[Naveen Kumar <naveenchowdaryon@xxxxxxxxx>]

Hi Laurenz,

Thanks for responding. Most of the time I am seeing wait event, same view if I create directly in source DB, it’s quick.

Thanks & Regards,

Naveen Kumar .M,

Sr. PostgreSQL Database Administrator,

Mobile: 7755929449.

On Thu, 4 Apr 2024 at 8:52 PM, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:

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