Re: High memory usage while querying with sort using cursor

2015-03-18 Thread Vaibhav Bhandari
Thanks Chris, that makes a lot of sense. On Wed, Mar 18, 2015 at 3:16 PM, Chris Hostetter wrote: > > : A simple query on the collection: ../select?q=*:* works perfectly fine. > : > : But as soon as i add sorting, it crashes the nodes with OOM: > : .../select?q=*:*&sort=unique_id asc&rows=0. >

Re: High memory usage while querying with sort using cursor

2015-03-18 Thread Chris Hostetter
: A simple query on the collection: ../select?q=*:* works perfectly fine. : : But as soon as i add sorting, it crashes the nodes with OOM: : .../select?q=*:*&sort=unique_id asc&rows=0. if you don't have docValues="true" on your unique_id field, then sorting rquires it to build up a large in mem

High memory usage while querying with sort using cursor

2015-03-18 Thread Vaibhav Bhandari
Hi all, My setup is as follows: *Collection* size: 32GB, 2 shards, replication factor: 2 (~16GB on each replica). Number of rows: 250million 4 *Solr* nodes: RAM: 30GB each. Heap size: 8GB. Version: 4.9.1 Besides the collection in question, the nodes have some other collections present. The total