CREATE VIEW conditions_summary_h
WITH (timescaledb.continuous) AS
SELECT device,
       time_bucket(INTERVAL '1 hour', time_) AS bucket,
       AVG(temperature),
       MAX(temperature),
       MIN(temperature)
FROM conditions
GROUP BY device, bucket;

SELECT device,
       time_bucket(INTERVAL '1 hour', time_) AS bucket,
       AVG(temperature),
       MAX(temperature),
       MIN(temperature)
FROM conditions
GROUP BY device, bucket;

# - Asynchronous Behavior -

#effective_io_concurrency = 0		# 1-1000; 0 disables prefetching
max_worker_processes = 15		# (change requires restart)
#max_parallel_maintenance_workers = 2	# taken from max_parallel_workers
max_parallel_workers_per_gather = 4	# taken from max_parallel_workers
#parallel_leader_participation = on
max_parallel_workers = 4		# maximum number of max_worker_processes that
					# can be used in parallel operations
#old_snapshot_threshold = -1		# 1min-60d; -1 disables; 0 is immediate
					# (change requires restart)
#backend_flush_after = 0		# measured in pages, 0 disables