The Postgres documentation says that materialized views with concurrent refreshes generate bloat as usual tables, because it executes deletes and inserts. For usual tables, there are some queries to monitor the table bloat.

Is there a way to monitor bloat on materialized views?

| improve this question | | | | |
  • 5
    A materialized view is a table as well. You can use the same queries – a_horse_with_no_name Oct 2 '18 at 14:06

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.