QuestDB

Pros

Optimized for analytical queries like aggregations, filtering and time-based sampling; It isn’t designed to handle frequent, fine‑grained transactional operations (OLTP) such as multi‑row updates or complex transactional consistency.
Lacks transactional features

On disk, it creates a directory for each partition. Sample Query

CREATE TABLE STUFF(
	a long,
	b string,
	c timestamp
) timestamp(c) PARTITION BY YEAR;

You can even detach or attach a partition when they are not relevant.

ALTER TABLE btc detach partition list '2012';

On disk, the folder will be renamed to 2012.detached.

To attach it back, mv 2012.detached 2012.attachable

ALTER TABLE btc attach partition list '2012';