Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general