Michael Ströder michael@stroeder.com schrieb am 17.08.2019 um 20:37 in
Nachricht 123c2421-b539-14cb-6c82-44235675b5cd@stroeder.com:
On 8/17/19 2:52 PM, Marc Roos wrote:
Over time I am adding indexes until there are no such messages (except for some incidental queries).
And that's exactly the wrong thing to do! That's why I requested to disable those messages in ITS#7796:
https://www.openldap.org/its/index.cgi?findid=7796
By adding random indexes just to get rid of not-indexed warnings you can dramatically lower your search performance. You should only add an index if you analyzed that clients send search requests with filters which can make good use of the index.
I agree that some thinking before adding an index isn't a bad idea, but still I think these messages are important as they can make you start thinking.
Learn about search candidate sets: https://unix.stackexchange.com/a/457561
LDAP filters used by clients can be seen with loglevel stats.
Ciao, Michael.