Re: pgsql: Skip full index scan during cleanup of B-tree indexes when possi - Mailing list pgsql-committers

From Peter Geoghegan
Subject Re: pgsql: Skip full index scan during cleanup of B-tree indexes when possi
Date
Msg-id CAH2-Wz=5_Y9e=sSVQjpOqDA=CTLAgEuL=V+jLfNeX9=BKxnm2g@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Skip full index scan during cleanup of B-tree indexes when possi  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
On Wed, Apr 4, 2018 at 8:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> This was discovered while testing/reviewing the latest version of the
>> INCLUDE covering indexes patch. It now seems to be unrelated.
>
> Oh, wait ... I wonder if you saw that because you were running a new
> backend without having re-initdb'd?

Yes. That's what happened.

> Once you had re-initdb'd, then
> of course there would be no old-format btree indexes anywhere.  But
> if you hadn't, then anyplace that was not prepared to cope with the
> old header format would complain about pre-existing indexes.
>
> In short, this sounds like a place that did not get the memo about
> how to cope with un-upgraded indexes.

Sounds plausible.

-- 
Peter Geoghegan


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Skip full index scan during cleanup of B-tree indexes when possi
Next
From: Simon Riggs
Date:
Subject: pgsql: MERGE post-commit review