I'm extremely new to infinidb so please bear with me. I'm working with a time series data table in a single server setting with hundreds of millions of rows, and I need to join the table with itself for some analysis. I will be updating the table too with the calculated results. I've read on the tuning guide that I can tweak the PmMaxMemorySmallSide field for joining smaller tables, but what's the best way for joining large tables like in my case? Also, I keep running out of memory on the server - is NumBlocksPct the correct field to fix that?
I'm running infinidb community on a Linux server with about 100G of memory.
Here are my settings for hash join:
Thanks very much in advance