Re: Create Materialized View from postgresql_fdw hang

Thanks.

On Fri, 5 Apr 2024 at 12:53 AM, jwiencek3 <jwiencek3(at)comcast(dot)net> wrote:

> You can probably check the size of the materialized view since they occupy
> physical space on disk. Periodic checking should show increase in size
>
>
>
> Sent via the Samsung Galaxy S22+ 5G, an AT&T 5G smartphone
>
>
> -------- Original message --------
> From: Naveen Kumar <naveenchowdaryon(at)gmail(dot)com>
> Date: 4/4/24 3:08 PM (GMT-05:00)
> 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
>
> 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
>>
>