I regularly do data-analysis tasks, where I just want to slurp in a few CSV files, join them together, with the theta function being usually inner and left/right joins, filter out some rows further, and finally output results
Currently I uses SAS for this.
Sounds fairly simple, until I tell you that the CSV files can be tens of GBs and there will be a minimum of 3 such tables that will need to be loaded (joined)
Hardware usually has 8GB of free physical RAM (the OS and other programs consume the rest) and an almost idle quadcore CPU
Can kdb+ CARRY OUT THESE JOINs without requiring me to use a DB like Postgres/ParAccel?