I have a few Solr indexes, each with 20-200 millions documents, which were indexed by querying multiple PostgreSQL databases. If I do rebuild the index by the same way, it would take a few months, because the PostgresSQL query is slow.
Now, I need to do the following changes to all indexes. 1. delete a couple fields from the Solr index 2. add a couple new fields 3. change the type of one field from string to int Luckily, all fields were "indexed and stored". My plan is to query an old index, and get values for all fields, and then add them into new index. Any faster ways to build new indexes in my case? Thanks, Ming
