| From: | jwiencek3 <jwiencek3(at)comcast(dot)net> |
|---|---|
| To: | Naveen Kumar <naveenchowdaryon(at)gmail(dot)com>, 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 21:53:11 |
| Message-ID: | sV1Dr0Jg4edqBsV1IrnPcM.1712267605.d5dcebd9fa1c9541629d4ecfcd291697.MISSINGID@comcast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
You can probably check the size of the materialized view since they occupy physical space on disk. Periodic checking should show increase in sizeSent 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jaya kumar | 2024-04-05 06:53:46 | Table DML status check per day |
| Previous Message | Naveen Kumar | 2024-04-04 19:08:08 | Re: Create Materialized View from postgresql_fdw hang |