Re: Create Materialized View from postgresql_fdw hang

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks.




On Fri, 5 Apr 2024 at 12:53 AM, jwiencek3 <jwiencek3@xxxxxxxxxxx> 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@xxxxxxxxx>
Date: 4/4/24 3:08 PM (GMT-05:00)
To: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>
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.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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux