On Wed, Jan 13, 2021 at 12:36 AM Heikki Linnakangas <[email protected]> wrote: > Add functions to 'pageinspect' to inspect GiST indexes.
Is gist_page_items() robust with deleted pages? I think that it's unsafe to assume that deleted pages will have index tuples, since the page contents will actually be a GISTDeletedPageContents. Simplest fix would be to assume maxoff is 0 for the page, perhaps. Right now we just use PageGetMaxOffsetNumber(), which implicitly assumes that the page uses slotted tuples with an array of line pointers (actually it can also deal with a zeroed page, but that's not relevant here). -- Peter Geoghegan
