Re: Checking for missing heap/index files - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Checking for missing heap/index files
Date
Msg-id CAH2-Wz=CCAWyPp487JPsrvr2gDgv+AAeBp-VoSfGSJB-XaAQgQ@mail.gmail.com
Whole thread Raw
In response to Re: Checking for missing heap/index files  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Thu, Jun 9, 2022 at 11:46 AM Bruce Momjian <bruce@momjian.us> wrote:
> I don't have a need for it --- I was just wondering why we have
> something that checks the relation contents, but not the file existence?

We do this for B-tree indexes within amcheck. They must always have
storage, if only to store the index metapage. (Actually unlogged
indexes that run on a standby don't, but that's accounted for
directly.)

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: BTMaxItemSize seems to be subtly incorrect
Next
From: Stephen Frost
Date:
Subject: Re: Checking for missing heap/index files