Re: Create Materialized View from postgresql_fdw hang

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Naveen Kumar <naveenchowdaryon(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Create Materialized View from postgresql_fdw hang
Date: 2024-04-04 17:52:04
Message-ID: cedd9bc4b8f02e84fb321dda448dc5480fe93115.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Naveen Kumar 2024-04-04 19:08:08 Re: Create Materialized View from postgresql_fdw hang
Previous Message Naveen Kumar 2024-04-04 12:07:42 Create Materialized View from postgresql_fdw hang