On 2/6/2019 12:42 AM, Yasufumi Mizoguchi wrote:
I am using Solr 7.6 and want to reduce index size due to hardware
limitation.
I already tried to
1. set false to unnecessary field's indexed/stored/docValues parameter in
schema.
2. set compressionMode="BEST_COMPRESSION" in solrconfig.
These were quite good, but I still need to reduce index size.
Then, I am now planning to set stored="false" in *PointFields only used for
range query,
faceting and sorting. Because I think that docValues="true" is enough to
acquire field's
value thanks to useDocValuesAsStored parameter.
But I also think this might lead to bad query performance...
Stored values have pretty much zero bearing on query performance.
Stored is smaller than docValues -- it's compressed, and docValues aren't.
If you do not need docValues for some other aspect, like faceting or
sorting, then choose stored. If you need docValues for something, then
choose docValues.
Removing either docValues or stored on a numeric type is probably not
going to make much difference in the total size of the index unless
there are billions of documents.
On a point type, queries like "field:333" will be slow. This is the
nature of a point type. If you will frequently make queries for
individual values, the Trie types (deprecated, will be removed in 8.0)
are better. Range queries (like "field:[444 TO 555]") perform best on a
point type.
Thanks,
Shawn
