есть одно интересное расширение для Postgre, которое именно так и функционирует
cstore_fdw
To load or append data into a cstore table, you have two options:

You can use the COPY command to load or append data from a file, a program, or STDIN.
You can use the INSERT INTO cstore_table SELECT ... syntax to load or append data from another table.
You can use the ANALYZE command to collect statistics about the table. These statistics help the query planner to help determine the most efficient execution plan for each query.

Note. We currently don't support updating table using DELETE, and UPDATE commands. We also don't support single row inserts.
+ все те "плюшки", которые даёт колумнстори индекс : в разы меньший объем хранения и стабильное, достаточно небольшое время выборки