pgsql: Update parallel BTree scan state when the scan keys can't be sat

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема pgsql: Update parallel BTree scan state when the scan keys can't be sat
Дата
Msg-id E1kIrX2-0004GB-9d@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Update parallel BTree scan state when the scan keys can't be satisfied.

For parallel btree scan to work for array of scan keys, it should reach
BTPARALLEL_DONE state once for every distinct combination of array keys.
This is required to ensure that the parallel workers don't try to seize
blocks at the same time for different scan keys. We missed to update this
state when we discovered that the scan keys can't be satisfied.

Author: James Hunter
Reviewed-by: Amit Kapila
Tested-by: Justin Pryzby
Backpatch-through: 10, where it was introduced
Discussion: https://postgr.es/m/4248CABC-25E3-4809-B4D0-128E1BAABC3C@amazon.com

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/fcc3665a03a644204d0a3fdf8ec138e3ec93e593

Modified Files
--------------
src/backend/access/nbtree/nbtsearch.c | 4 ++++
1 file changed, 4 insertions(+)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Allow CURRENT_ROLE where CURRENT_USER is accepted
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Improve common/logging.c's support for multiple verbosity levels