postgresql – Refreshing part of the materialized view in Postgres

I am new to Postgres. Is there a way to update part of the data in a materialized view? I think this would be beneficial for my application compared to a traditional view, as several joins will be involved and it would be good to have a near instantaneous report on the data obtained.

My view would have columns similar to:

  • User ID (indexed)
  • Account ID (indexed)
  • DataColumn1
  • DataColumn2

For example, I would like to update all lines that have a certain User ID or Account ID on demand.