Re: Create Materialized View from postgresql_fdw hang

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Create Materialized View from postgresql_fdw hang
Дата
Msg-id cedd9bc4b8f02e84fb321dda448dc5480fe93115.camel@cybertec.at
обсуждение исходный текст
Ответ на [MASSMAIL]Create Materialized View from postgresql_fdw hang  (Naveen Kumar <naveenchowdaryon@gmail.com>)
Ответы Re: Create Materialized View from postgresql_fdw hang  (Naveen Kumar <naveenchowdaryon@gmail.com>)
Список 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



В списке pgsql-admin по дате отправления:

Предыдущее
От: Naveen Kumar
Дата:
Сообщение: [MASSMAIL]Create Materialized View from postgresql_fdw hang
Следующее
От: Naveen Kumar
Дата:
Сообщение: Re: Create Materialized View from postgresql_fdw hang