The best way to determine the setup that provides the best performance is to perform your own tests. For example, try loading data and runnign queries with different numbers and sizes of nodes. This way, you will have results that…
Here is a way, demo at SQL Fiddle CREATE TABLE Table1 (“id” int, “datetime” time, “name” varchar(1)) ; INSERT INTO Table1 (“id”, “datetime”, “name”) VALUES (1, ’11:10:01′, ‘A’), (1, ’11:10:02′, ‘A’), (1, ’11:10:05′, ‘B’), (1, ’11:12:02′, ‘A’), (1, ’11:12:10′, ‘A’),…
This query: SELECT to_char(generate_series(0, 23) * interval ‘1 hour’ + ‘2019-01-01 00:00:00’::timestamp, ‘HH24:MI’) will return: 00:00 01:00 02:00 03:00 … 23:00 Just modify the format string for what you desire. 0 solved generate_series for every hour in hh24:mi:ss format