With pond you just point it at an S3 bucket or a local directory. Under the hood is in-process Lance. It also supports safe concurrent writes, so I just collect all my sessions from all my local machines, remote VMs and telegram agent setups in one bucket dir. Right now that is 14,861 sessions, 2.83M messages, 10.6 GiB, from 8 tools (Claude Code, Codex, opencode, pi, Claude Desktop, oh-my-pi and a few more).
The one thing I really want to get optimized is remote storage read speeds. Local queries run in milliseconds to two seconds on my whole corpus, while remote storage is still 20-30 seconds per call. My goal is to get them on par.
What I would really want to know is which client to support next, and whether keeping the vector search and all of that embedded-model hassle is worth its keep. FTS-only would have been much faster, and there is hardly any good benchmark I can find that could help me close this question.