Basically correct. If you have less than tens-of-terabytes the big exciting stuff just isn't needed and isn't particularly helpful.
Focus on understanding your data and building a useful model.
Use Postgres if you can. Supplement with DuckDB and/or ClickHouse as needed. Or, use your cloud's columnar DB (Redshift, BQ, Azure whatever) because you can start and stop using it as you please without talking to sales or signing a contract.
If your data team doesn't have the requisite skills... well... consider that tech selection might not be your problem.
Focus on understanding your data and building a useful model.
Use Postgres if you can. Supplement with DuckDB and/or ClickHouse as needed. Or, use your cloud's columnar DB (Redshift, BQ, Azure whatever) because you can start and stop using it as you please without talking to sales or signing a contract.
If your data team doesn't have the requisite skills... well... consider that tech selection might not be your problem.