Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Projection refresh taking too long
Projection refresh that used to take ~6 hours was running for 44 hours before we canceled it. The only change we made prior to that was enabling local segmentation (with scaling factor = 16). We restarted the cluster and started the refresh again, but are afraid that we will bump into the same problem. We ran select * from projection_refreshes; to figure out the session_id and then queried: SELECT * FROM execution_engine_profiles WHERE session_id = '?' which now returns an empty row. Is this expected behaviour? How can we check that projection refresh is running smoothly and get an estimate of time it will need to complete?