pgsql: In PageIndexTupleDelete, don't assume stored item lengths are MA

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: In PageIndexTupleDelete, don't assume stored item lengths are MA
Дата
Msg-id E1biOYM-0005lQ-Ik@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
In PageIndexTupleDelete, don't assume stored item lengths are MAXALIGNed.

PageAddItem stores the item length as-is.  It MAXALIGN's the amount of
space actually allocated for each tuple, but not the stored length.
PageRepairFragmentation, PageIndexMultiDelete, and PageIndexDeleteNoCompact
are all on board with this and MAXALIGN item lengths after fetching them.
But PageIndexTupleDelete expects the stored length to be a MAXALIGN
multiple already.  This accidentally works for existing index AMs because
they all maxalign their tuple sizes internally; but we don't do that for
heap tuples, and it shouldn't be a requirement for index tuples either.

So, sync PageIndexTupleDelete with the rest of bufpage.c by having it
maxalign the item size after fetching.

Also add a check that pd_special is maxaligned, to ensure that the test
"(offset + size) > phdr->pd_special" is still doing the right thing.
(If offset and pd_special are aligned, it doesn't matter whether size is.)
Again, this is in sync with the rest of the routines here, except for
PageAddItem which doesn't test because it doesn't actually do anything
for which pd_special alignment matters.

This shouldn't have any immediate functional impact; it just adds the
flexibility to use PageIndexTupleDelete on index tuples with non-aligned
lengths.

Discussion: <3814.1473366762@sss.pgh.pa.us>

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/984d0a14e8d0141a68da5bd56ce6821042298904

Modified Files
--------------
src/backend/storage/page/bufpage.c | 8 ++++++--
1 file changed, 6 insertions(+), 2 deletions(-)


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Make better use of existing enums in plpgsql
Следующее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: Fix locking a tuple updated by an aborted (sub)transaction