Re: Legacy GiST invalid tuples - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Legacy GiST invalid tuples
Date
Msg-id 66377.1530717730@sss.pgh.pa.us
Whole thread Raw
In response to Legacy GiST invalid tuples  (Andrey Borodin <x4mmm@yandex-team.ru>)
Responses Re: Legacy GiST invalid tuples
List pgsql-hackers
Andrey Borodin <x4mmm@yandex-team.ru> writes:
> There is bunch of code in current GiST implementation checking for GistTupleIsInvalid(). PostgreSQL since 9.1 do not
createinvalid tuples. Should we support this tuples forever? 

The question is not whether we still create such tuples.  The reason
the code is still there is that an index that's been pg_upgraded from
before 9.1 might still contain such tuples.  We can't drop the support
unless either we provide logic to clean up invalid entries, or we're
willing to force users to REINDEX old GiST indexes to get rid of them
that way.  The latter seems like a pretty high price just to get rid of
some crufty old code.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Locking considerations of REINDEX
Next
From: Andrey Borodin
Date:
Subject: Re: Legacy GiST invalid tuples