Postgres Pro
Downloads
Home   >   mailing lists

[MASSMAIL]Create Materialized View from postgresql_fdw hang - Mailing list pgsql-admin

From Naveen Kumar
Subject [MASSMAIL]Create Materialized View from postgresql_fdw hang
Date
Msg-id CADk76jpVFzaNFwc6oxfJO8wfVR-2XtRskmrNNkyPEWy3i21iJQ@mail.gmail.com
Whole thread Raw
Responses Re: Create Materialized View from postgresql_fdw hang
List pgsql-admin
Tree view
Hi All,

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. 
In the source server, the state is "idle in transaction" and the query is "FETCH 100 FROM c1". Any suggestions on how to speed this up?




Thanks & Regards,
Naveen Kumar .M,
Sr. PostgreSQL Database Administrator,
Mobile: 7755929449.

pgsql-admin by date:

Previous
From: Samed YILDIRIM
Date:
Subject: Re: Postgresql - Pgbouncer Connection and Query Performance Problem
Next
From: Laurenz Albe
Date:
Subject: Re: Create Materialized View from postgresql_fdw hang