Revert most of 39b66a91bd
Tomas Vondra <tomas.vondra@postgresql.org>
Revert most of 39b66a91bd Reverts most of commit 39b66a91bd, which was found to cause significant regression for REFRESH MATERIALIZED VIEW. This means only rows inserted by heap_multi_insert will benefit from the optimization, implemented in commit 7db0cd2145. Reported-by: Masahiko Sawada Discussion: https://postgr.es/m/CAD21AoA%3D%3Df2VSw3c-Cp_y%3DWLKHMKc1D6s7g3YWsCOvgaYPpJcg%40mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/access/heap/heapam.c | modified | +1 −73 |
| src/backend/access/heap/hio.c | modified | +11 −11 |
Discussion
- Performance degradation of REFRESH MATERIALIZED VIEW 60 messages · 2021-03-11 → 2021-06-04