Fork me on GitHub
#xtdb
<
2023-02-20
>
tatut09:02:59

the new :enable-filters? RocksDB option doesn’t seem to be documented in https://docs.xtdb.com/storage/1.23.0/rocksdb/

👍 2
refset10:02:49

Thanks for flagging, I'll get that fixed. Have you tried it out with your workload already? Part of the reason it's not "on by default" is because we observed mixed results for performance improvements depending on the kinds of data and queries involved. Like it's not a universal 'win'

tatut10:02:49

the release notes mentions “improvements”, any measurements on how big those are?

tatut10:02:58

haven’t tried yet

tatut10:02:20

but I’m interested in trying because I have a case with a massive conversion of data form another system that does the “writing an entity for the first time” a lot

👍 2
refset10:02:36

I'll see if I can dig out a number or two. I believe @U8ZQ1J1RR tried :enable-filters? and saw improvements

refset10:02:45

> I have a case with a massive conversion of data form another system that does the “writing an entity for the first time” a lot I suspect you'd see improvements in that case. At least during the initial load.

tatut10:02:38

it warns about the block cache, I currently already have it set to 512mb

tatut11:02:03

well, I increased it to 1 gigabyte and we’ll see

👍 2