mrjones-plip opened a new issue, #5894: URL: https://github.com/apache/couchdb/issues/5894
### Version unknown ### Describe the problem you're encountering We're testing a database with ~1mil synthetic docs and bench-marks in CouchDB 3.5.0 indexing one Nouveau index took 184,828 ms. In CouchDb 3.5.1 the same index took 2,683,576 ms - a ~14x slow down! Initially it was thought the Nouveau setting of `maxIndexesOpen` from `3000` to `100` might have caused this, but the times above have `maxIndexesOpen=3000`. Changing `pool_size = 1000` did not help either. For reference, benchmarks for [3.5.0](https://github.com/medic/scalability-results/blob/main/results/10646-add-indexing-benchmark-22101618369/benchmark_results.md) and for [3.5.1](https://github.com/medic/scalability-results/blob/main/results/copy-of-shashi-couch-upgrade-take-2-22109717239/benchmark_results.md) and are the [Nouveau configs](https://github.com/medic/cht-core/blob/copy-of-shashi-couch-upgrade-take-2/couchdb-nouveau/nouveau.yaml) used in 3.5.1, in 3.5.0 we made no changes to configs. ### Expected Behaviour There should be no regression in Nouveau indexing between 3.5.0 and 3.5.1 ### Steps to Reproduce 1. create a 3.5.0 Nouveau database with 1million docs 2. rebuild index, note time 3. upgrade to 3.5.1 4. rebuild index, note time increase ### Your Environment Docker with CouchDB 3.5.1 ### Additional Context Discovered when testing CouchDB 3.5.1 for [the CHT](https://github.com/medic/cht-core/issues/10455) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
