Return
-
Title
post slow due to materialized view -
Description
poster applies messages very slow, and it is even slower when there are more commit messages.
-
Cause
The table is a based table for a materialized view, and the materialized view was set to be refreshed on commit.
-
Resolution
alter materialized view to have it refreshed on demand.