Help on database for efficient group bys
Select device_id, min(signal_date_time) from signals where signal_date_time >= ‘specific_date_time_value’ group by device_id;
There are more where conditions, but essentially I can have millions of rows per device. After my where conditions I know I can have around 100000 devices. I need to be able to do this query in under 1 second for concurrent queries.
So far I’ve tried modeling this in: - clickhouse - Postgres - mongodb
Any help would be greatly appreciated!