Some people are using DuckDB for large datasets, https://duckdb.org/docs/stable/guides/performance/working_with_huge_databases https://duckdb.org/docs/stable/gu

Some people are using DuckDB for large datasets, https://duckdb.org/docs/stable/guides/performance/working_with_huge_databases https://duckdb.org/docs/stable/guides/performance/working_wi... , but you'd probably do some testing under the specific conditions of your rig to figure out if it is a good match or not.