On Sun, 2014-03-09 at 19:55 +0100, abhishek jain wrote: > I am confused should i keep two separate indexes or keep one index with two > versions or column , i mean col1_stemmed and col2_unstemmed.
1 index with stemmed & unstemmed will be markedly smaller than 2 indexes (one with stemmed, one with unstemmed). Furthermore, keeping the stemmed and unstemmed in the same index allows you to search in both fields and assign a greater weight to the unstemmed field. > I have multicore with multi shard configuration. > My server have 32 GB RAM and stemmed index size (without content) i > calculated as 60 GB . What do you mean by "without content"? Is it the col2_unstemmed that you plan to add? Or stored fields maybe? > I want to not put too much load and I/O load on a decent server with some 5 > other replicated servers and want to use servers for other purposes also. If you haven't already done so, use SSDs as your storage. That way you don't have to worry much about RAM / index size ratio for performance. - Toke Eskildsen, State and University Library, Denmark
