pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl
Дата
Msg-id E1rmBlc-004RCt-GD@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix EXPLAIN Bitmap heap scan to count pages with no visible tuples

Previously, bitmap heap scans only counted lossy and exact pages for
explain when there was at least one visible tuple on the page.

heapam_scan_bitmap_next_block() returned true only if there was a
"valid" page with tuples to be processed. However, the lossy and exact
page counters in EXPLAIN should count the number of pages represented
in a lossy or non-lossy way in the constructed bitmap, regardless of
whether or not the pages ultimately contained visible tuples.

Backpatch to all supported versions.

Author: Melanie Plageman
Discussion: https://www.postgresql.org/message-id/CAAKRu_ZwCwWFeL_H3ia26bP2e7HiKLWt0ZmGXPVwPO6uXq0vaA@mail.gmail.com
Discussion: https://www.postgresql.org/message-id/CAAKRu_bxrXeZ2rCnY8LyeC2Ls88KpjWrQ%2BopUrXDRXdcfwFZGA@mail.gmail.com

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/992189a3e94d27f555c856626c2d45b898571826

Modified Files
--------------
src/backend/executor/nodeBitmapHeapscan.c     | 10 +++++-----
src/test/regress/expected/partition_prune.out |  5 ++++-
2 files changed, 9 insertions(+), 6 deletions(-)


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Add some const decorations
Следующее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: Put libpq_pipeline cancel test back