Re: GIN improvements part 1: additional information

On Thu, Oct 3, 2013 at 02:48:20PM -0400, Robert Haas wrote:
> On Thu, Oct 3, 2013 at 2:43 PM, Heikki Linnakangas
> <hlinnakangas(at)vmware(dot)com> wrote:
> > It seems we've all but decided that we'll require reindexing GIN indexes in
> > 9.4.
>
> I thought the consensus in Ottawa was strongly against that. I'm not
> aware that anyone has subsequently changed their position on the
> topic. Bruce is right to point out that we've done such things before
> and can therefore do it again, but just because we have the technical
> means to do it doesn't make it good policy.
>
> That having been said, if we do decide to break it...

Agreed. I was stating only that this is easy for pg_upgrade. One cool
thing is that the upgrades completes, and the indexes are there, but
just marked as invalid until the REINDEX.

One other point Alexander made is that the new GIN indexes will be
smaller so most people would want the new format in the new cluster
anyway.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +