Re: I don't want to back up index files - Mailing list pgsql-general

Alvaro Herrera <alvherre@commandprompt.com> writes:
> FWIW I don't think this idea is silly at all.  It's so not-silly, in
> fact, that we already have some access methods that do this if an index
> cannot be recovered (I think at least GiST does it).

Well, there's a difference between "rebuild the index when it can't be
recovered" and "lose the index anytime the system burps".  AFAICS what
Glen is proposing is to not WAL-log index changes, and with that any
crash no matter how minor would have to invalidate indexes.

            regards, tom lane