[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16686997#comment-16686997 ] David Smiley commented on SOLR-11078: - Thanks Gerd; you are welcome! It's not every

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16686906#comment-16686906 ] bidorbuy commented on SOLR-11078: - Hi all, ex CTO from bidorbuy here. I had planned to m

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16686873#comment-16686873 ] Adrien Grand commented on SOLR-11078: - I'm not aware of such benchmarks, but I've had

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16686856#comment-16686856 ] David Smiley commented on SOLR-11078: - [~jpountz] or [~mikemccand] are you aware of a

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16392390#comment-16392390 ] David Smiley commented on SOLR-11078: - I filed SOLR-12074 (linked to this one). At th

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16390798#comment-16390798 ] Shawn Heisey commented on SOLR-11078: - bq. Would be it good to put back trie-fields in

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16390763#comment-16390763 ] Sachin Goyal commented on SOLR-11078: - This degradation in query performance can be a

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16370625#comment-16370625 ] Uwe Schindler commented on SOLR-11078: -- I'd use the good old numericfield encoding. O

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16370568#comment-16370568 ] Shawn Heisey commented on SOLR-11078: - bq. What about faceting/pivoting and what about

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16370472#comment-16370472 ] Sachin Goyal commented on SOLR-11078: - Thanks [~jpountz] for a good detailed reply. S

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16370239#comment-16370239 ] Shawn Heisey commented on SOLR-11078: - If there are things we can do in Solr to improv

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16370116#comment-16370116 ] Adrien Grand commented on SOLR-11078: - Actually Tomas just let me know that Solr alrea

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16369875#comment-16369875 ] Adrien Grand commented on SOLR-11078: - {quote}Do we know why the point fields are less

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16369787#comment-16369787 ] Shawn Heisey commented on SOLR-11078: - bq. Also, when trie-fields were first deprecate

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16369768#comment-16369768 ] Sachin Goyal commented on SOLR-11078: - Do we know why the point fields are less perfor

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16280813#comment-16280813 ] Markus Jelsma commented on SOLR-11078: -- I agree with Yonik, Strings are no substitute

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16280457#comment-16280457 ] Adrien Grand commented on SOLR-11078: - bq. I would either leave out the "or use StrFie

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16280422#comment-16280422 ] ASF subversion and git services commented on SOLR-11078: Commit 12

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16280417#comment-16280417 ] ASF subversion and git services commented on SOLR-11078: Commit 29

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16280414#comment-16280414 ] ASF subversion and git services commented on SOLR-11078: Commit d8

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16279312#comment-16279312 ] Yonik Seeley commented on SOLR-11078: - I would either leave out the "or use StrField",

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16279297#comment-16279297 ] David Smiley commented on SOLR-11078: - [~jpountz] as the RM for 7.2, do you think we c

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16242115#comment-16242115 ] Yonik Seeley commented on SOLR-11078: - bq. however simple field:value queries underper

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16242096#comment-16242096 ] bidorbuy commented on SOLR-11078: - My experience about the CHANGES.TXT (and I typically re

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16242068#comment-16242068 ] David Smiley commented on SOLR-11078: - bq. To be clear, what is the official recommend

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16241830#comment-16241830 ] Markus Jelsma commented on SOLR-11078: -- To be clear, what is the official recommendat

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16241563#comment-16241563 ] bidorbuy commented on SOLR-11078: - Thanks for the detailed responses [~dsmiley]. We have s

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16241467#comment-16241467 ] David Smiley commented on SOLR-11078: - Minor correction: Some Point fields can be unin

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16240871#comment-16240871 ] David Smiley commented on SOLR-11078: - bq. Is there more documentation available about

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16239384#comment-16239384 ] bidorbuy commented on SOLR-11078: - Will will switch 7.1 into full production load tonight

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16237574#comment-16237574 ] David Smiley commented on SOLR-11078: - @bidorbuy Thanks so much for sharing your real

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16237277#comment-16237277 ] bidorbuy commented on SOLR-11078: - Thank you [~jpountz] for the explanation. We have now b

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16237257#comment-16237257 ] Adrien Grand commented on SOLR-11078: - bq. Maybe we should update recommendations inst

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16237239#comment-16237239 ] bidorbuy commented on SOLR-11078: - [~jpountz] could you perhaps point me to Solr documenta

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16237115#comment-16237115 ] bidorbuy commented on SOLR-11078: - Just some more feedback - we still need to run a few mo

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16236794#comment-16236794 ] Yonik Seeley commented on SOLR-11078: - bq. Maybe we should update recommendations inst

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16236792#comment-16236792 ] Yonik Seeley commented on SOLR-11078: - bq. . Some indexes we haven't reverted use Poin

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16236299#comment-16236299 ] Adrien Grand commented on SOLR-11078: - Adding points and terms to the same field would

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16236296#comment-16236296 ] Shawn Heisey commented on SOLR-11078: - Adding the full-precision terms to increase per

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16236242#comment-16236242 ] Shawn Heisey commented on SOLR-11078: - bq. So what we might want to do is index full-

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16236150#comment-16236150 ] Markus Jelsma commented on SOLR-11078: -- Hello David, The particular index we revert

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16236123#comment-16236123 ] David Smiley commented on SOLR-11078: - bq. Possibly dumb question: Can a term be added

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16236036#comment-16236036 ] Yonik Seeley commented on SOLR-11078: - Seems like deprecation of trie fields may have

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16236026#comment-16236026 ] Erick Erickson commented on SOLR-11078: --- [~dsmiley] Any chance you could add that to

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16235991#comment-16235991 ] Shawn Heisey commented on SOLR-11078: - Possibly dumb question: Can a term be added to

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16235815#comment-16235815 ] David Smiley commented on SOLR-11078: - Are your queries searching for exact values, e.

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16235359#comment-16235359 ] bidorbuy commented on SOLR-11078: - Thank you [~markus17]. I am going to revert schemas bac

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16235350#comment-16235350 ] Markus Jelsma commented on SOLR-11078: -- We have observed it too, and immediately went

[jira] [Commented] (SOLR-11078) Solr query performance degradation since Solr 6.4.2

[ https://issues.apache.org/jira/browse/SOLR-11078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16235224#comment-16235224 ] bidorbuy commented on SOLR-11078: - We have 3 identical production servers. Two are running