Report syncscan position at end of scan.
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Thu, 31 Aug 2023 10:02:15 +0000 (13:02 +0300)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Thu, 31 Aug 2023 10:02:15 +0000 (13:02 +0300)
commite8d74ad625f7344f6b715254d3869663c1569a51
treef1b13bef7c455675427b9dc1e1bee65894e2cb4b
parentd7ceb41b9b84092517bbd7aa1ea6c446f023504e
Report syncscan position at end of scan.

The comment in heapgettup_advance_block() says that it reports the
scan position before checking for end of scan, but that didn't match
the code. The code was refactored in commit 7ae0ab0ad9, which
inadvertently changed the order of the check and reporting. Change it
back.

This caused a few regression test failures with a small shared_buffers
setting like 10 MB. The 'portals' and 'cluster' tests perform seqscans
that are large enough that sync seqscans kick in. When the sync scan
position is not updated at end of scan, the next seq scan doesn't
start at the beginning of the table, and the test queries are
sensitive to that.

Reviewed-by: Melanie Plageman, David Rowley
Discussion: https://www.postgresql.org/message-id/6f991389-ae22-d844-a9d8-9aceb7c01a9a@iki.fi
Backpatch-through: 16
src/backend/access/heap/heapam.c