On 2014-11-01 14:19:22 -0400, Andrew Dunstan wrote: > Isn't the planner still going to try to use the index in that case? If it's > not then I'd be OK with it, but if it's going to make the table largely > unusable until it's reindexed that would be rather sad.
Both the planner (for querying) and the executor (to avoid inserting tuples into the index) would have to query the state of such indexes. I don't think it can reasonably work otherwise. 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