Thread: Optimizing materialize views for refresh

Optimizing materialize views for refresh

From

Wells Oliver

Date:

23 June 2021, 22:20:49

Is there anything to be done beyond your normal SQL optimization considerations? Does temp_buffers have any effect on materialization, or any other under-the-hood settings we could be more cognizant of?

Wells Oliver
wells.oliver@gmail.com

Re: Optimizing materialize views for refresh

From

Vijaykumar Jain

Date:

23 June 2021, 22:32:22

other than general tuning, I think the below feature for future? versions maye be of great help.

PostgreSQL: Implementing Incremental View Maintenance

Incremental materialized view maintenance for PostgreSQL 14? - Blog dbi services (dbi-services.com)