On 2014-11-01 14:13:02 -0400, Andrew Dunstan wrote: > Yes, although there might not be much reason to use them either. I think > Tom's first step of making hash indexes automatically unlogged makes sense. > Longer term I'd like to see unlogged as an option for all AMs - especially > btree.
If we implement unlogged indexes, it should definitely work for all builtin indexes. > It makes plenty of sense to me to be able to make the data resilient > even if the indexes, which can after all be recreated in the unlikely event > of a crash, are not. While I agree that it can be useful, I think the fact that replicas/HS can't use such index makes them far less useful. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
