pgsql: Fix parallel BRIN builds with synchronized scans
| От | Tomas Vondra |
|---|---|
| Тема | pgsql: Fix parallel BRIN builds with synchronized scans |
| Дата | |
| Msg-id | E1rJhea-00Chmd-TM@gemulon.postgresql.org обсуждение исходный текст |
| Список | pgsql-committers |
Fix parallel BRIN builds with synchronized scans The brinbuildCallbackParallel callback used by parallel BRIN builds did not consider that the parallel table scans may be synchronized, starting from an arbitrary block and then wrap around. If this happened and the scan actually did wrap around, tuples from the beginning of the table were added to the last range produced by the same worker. The index would be missing range at the beginning of the table, while the last range would be too wide. This would not produce incorrect query results, but it'd be less efficient. Fixed by checking for both past and future ranges in the callback. The worker may produce multiple summaries for the same page range, but the leader will merge them as if the summaries came from different workers. Discussion: https://postgr.es/m/c2ee7d69-ce17-43f2-d1a0-9811edbda6e6%40enterprisedb.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/cb44a8345e7c248cf4158f2702fd9c9358399cfb Modified Files -------------- src/backend/access/brin/brin.c | 16 ++++++++++++---- 1 file changed, 12 insertions(+), 4 deletions(-)
В списке pgsql-committers по дате отправления: