From: | Naveen Kumar <naveenchowdaryon(at)gmail(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Create Materialized View from postgresql_fdw hang |
Date: | 2024-04-04 19:08:08 |
Message-ID: | CADk76joaezbonVX3dy2n3LeR-FBcr=ahh_o2Uz=Yb-HM_HZUCg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)albe(at)cybertec(dot)at>
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | jwiencek3 | 2024-04-04 21:53:11 | Re: Create Materialized View from postgresql_fdw hang |
Previous Message | Laurenz Albe | 2024-04-04 17:52:04 | Re: Create Materialized View from postgresql_fdw hang |