pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedhstore-new - hstore-new: fix edge-case bugs with empty arrays and nulls
7+ messages / 2 participants
[nested] [flat]
* hstore-new - hstore-new: fix edge-case bugs with empty arrays and nulls
@ 2009-07-19 02:14 User Andrewsn <andrewsn@pgfoundry.org>
0 siblings, 0 replies; 7+ messages in thread
From: andrewsn@pgfoundry.org @ 2009-07-19 02:14 UTC (permalink / raw)
To: pgsql-committers
Log Message:
-----------
fix edge-case bugs with empty arrays and nulls
Modified Files:
--------------
hstore-new:
hstore_io.c (r1.4 -> r1.5)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/hstore-new/hstore-new/hstore_io.c?r1=1.4&r2=1.5)
hstore-new/sql:
hstore.sql (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/hstore-new/hstore-new/sql/hstore.sql?r1=1.2&r2=1.3)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl
@ 2024-03-18 12:07 Heikki Linnakangas <heikki.linnakangas@iki.fi>
0 siblings, 0 replies; 7+ messages in thread
From: Heikki Linnakangas @ 2024-03-18 12:07 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
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...
Discussion: https://www.postgresql.org/message-id/CAAKRu_bxrXeZ2rCnY8LyeC2Ls88KpjWrQ%2BopUrXDRXdcfwFZGA@mail.gma...
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/0960ae1967d0569be4d118c20e51a2ed98d76f65
Modified Files
--------------
src/backend/executor/nodeBitmapHeapscan.c | 10 +++++-----
src/test/regress/expected/partition_prune.out | 4 +++-
2 files changed, 8 insertions(+), 6 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl
@ 2024-03-18 12:07 Heikki Linnakangas <heikki.linnakangas@iki.fi>
0 siblings, 0 replies; 7+ messages in thread
From: Heikki Linnakangas @ 2024-03-18 12:07 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
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...
Discussion: https://www.postgresql.org/message-id/CAAKRu_bxrXeZ2rCnY8LyeC2Ls88KpjWrQ%2BopUrXDRXdcfwFZGA@mail.gma...
Branch
------
REL_16_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/1f4eb734200a2420f45d0204d95b65ddf707888c
Modified Files
--------------
src/backend/executor/nodeBitmapHeapscan.c | 10 +++++-----
src/test/regress/expected/partition_prune.out | 4 +++-
2 files changed, 8 insertions(+), 6 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl
@ 2024-03-18 12:07 Heikki Linnakangas <heikki.linnakangas@iki.fi>
0 siblings, 0 replies; 7+ messages in thread
From: Heikki Linnakangas @ 2024-03-18 12:07 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
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...
Discussion: https://www.postgresql.org/message-id/CAAKRu_bxrXeZ2rCnY8LyeC2Ls88KpjWrQ%2BopUrXDRXdcfwFZGA@mail.gma...
Branch
------
REL_15_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/d3d95f5839952d5bfa089a318a9d11809eb48ac2
Modified Files
--------------
src/backend/executor/nodeBitmapHeapscan.c | 10 +++++-----
src/test/regress/expected/partition_prune.out | 4 +++-
2 files changed, 8 insertions(+), 6 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl
@ 2024-03-18 12:07 Heikki Linnakangas <heikki.linnakangas@iki.fi>
0 siblings, 0 replies; 7+ messages in thread
From: Heikki Linnakangas @ 2024-03-18 12:07 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
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...
Discussion: https://www.postgresql.org/message-id/CAAKRu_bxrXeZ2rCnY8LyeC2Ls88KpjWrQ%2BopUrXDRXdcfwFZGA@mail.gma...
Branch
------
REL_14_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/262757b73286d6dab2c563123ff11bee2b295e31
Modified Files
--------------
src/backend/executor/nodeBitmapHeapscan.c | 10 +++++-----
src/test/regress/expected/partition_prune.out | 4 +++-
2 files changed, 8 insertions(+), 6 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl
@ 2024-03-18 12:07 Heikki Linnakangas <heikki.linnakangas@iki.fi>
0 siblings, 0 replies; 7+ messages in thread
From: Heikki Linnakangas @ 2024-03-18 12:07 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
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...
Discussion: https://www.postgresql.org/message-id/CAAKRu_bxrXeZ2rCnY8LyeC2Ls88KpjWrQ%2BopUrXDRXdcfwFZGA@mail.gma...
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(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl
@ 2024-03-18 12:07 Heikki Linnakangas <heikki.linnakangas@iki.fi>
0 siblings, 0 replies; 7+ messages in thread
From: Heikki Linnakangas @ 2024-03-18 12:07 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
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...
Discussion: https://www.postgresql.org/message-id/CAAKRu_bxrXeZ2rCnY8LyeC2Ls88KpjWrQ%2BopUrXDRXdcfwFZGA@mail.gma...
Branch
------
REL_12_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/f3e4581acdc83258ff75a4c03950ff89762c98e6
Modified Files
--------------
src/backend/executor/nodeBitmapHeapscan.c | 10 +++++-----
src/test/regress/expected/partition_prune.out | 5 ++++-
2 files changed, 9 insertions(+), 6 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-03-18 12:07 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-07-19 02:14 hstore-new - hstore-new: fix edge-case bugs with empty arrays and nulls User Andrewsn <andrewsn@pgfoundry.org>
2024-03-18 12:07 pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl Heikki Linnakangas <heikki.linnakangas@iki.fi>
2024-03-18 12:07 pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl Heikki Linnakangas <heikki.linnakangas@iki.fi>
2024-03-18 12:07 pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl Heikki Linnakangas <heikki.linnakangas@iki.fi>
2024-03-18 12:07 pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl Heikki Linnakangas <heikki.linnakangas@iki.fi>
2024-03-18 12:07 pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl Heikki Linnakangas <heikki.linnakangas@iki.fi>
2024-03-18 12:07 pgsql: Fix EXPLAIN Bitmap heap scan to count pages with no visible tupl Heikki Linnakangas <heikki.linnakangas@iki.fi>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox