Create Materialized View from postgresql_fdw hang

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

 

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.

[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