I have a very large table and I summarize it in a materialized view. I then create an even smaller materialized view based on the earlier mview. The second mv is always showing zero rows. Is there a limitation in postgres that all mvs must be based off of a real table? I did a quick search of docs and didn't find anything.

table (millions of rows) -> mv A (thousands of rows) -> mv B (zero rows, but expected hundreds)

  • 1
    No, there is no such limitation. But you need to refresh them in the correct order. – a_horse_with_no_name Dec 1 '14 at 22:15
  • @a_horse_with_no_name looks like you are right. My refresh statements were out of order – Shahbaz Dec 1 '14 at 23:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.