Can I read from materialized view while it is in a process of refreshing?? Lets say query for the refresh take 2s and my website has, on average, a request per second. Will my site brake if I try to serve the request and materialized view is in process of refreshing????
What sort of platform / language is site using? Typically a database request would block an HTTP request from being complete until it has completed, unless you're using javascript or another mechanism to update after the initial HTTP request has been complete. Really need to know more about how your site is programmed and how it is making HTTP and database requests to answer this correctly.