Re: Checking for missing heap/index files

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Checking for missing heap/index files
Date: 2022-06-09 18:47:42
Message-ID: CAH2-Wz=CCAWyPp487JPsrvr2gDgv+AAeBp-VoSfGSJB-XaAQgQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jun 9, 2022 at 11:46 AM Bruce Momjian <bruce(at)momjian(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2022-06-09 19:28:37 Re: Checking for missing heap/index files
Previous Message Stephen Frost 2022-06-09 18:47:31 Re: BTMaxItemSize seems to be subtly incorrect