pg squeeze will support view and materialized view?

[cybertec-postgresql]

pg squeeze will support view and materialized view?

[ahouska]

View has no storage, so pg_squeeze cannot handle it. As for materialized view, why can't you simply use the REFRESH MATERIALIZED VIEW CONCURRENTLY command?

[vasanth-santharam]

Thanks for information and support.
we are using "REFRESH MATERIALIZED VIEW CONCURRENTLY", we have ~1000 millions records. It takes more than 5 mins.
so that we checked the alternative.

[AnanthGopal]

Hi @ahouska ,

In Postgres, materialized views use disc space. The command REFRESH MATERIALIZED VIEW CONCURRENTLY is used to refresh a specific materialized view, but it doesn't clear out any extra space. Therefore, we used the "Vacuum" command, which removes empty space from materialized views but takes a long time in our environment because we have a lot of data. Consequently, we attempt to use pg squeeze.