Thanks for the answers - makes a lot of sense. I'm replying to this one just to clarify one point:
> cstore_fdw has certain limitations, importantly it is not updatable
Does it support insert, or are tables completely immutable once created?
> cstore_fdw has certain limitations, importantly it is not updatable
Does it support insert, or are tables completely immutable once created?
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.
Note: We currently don't support updating table using DELETE, and UPDATE commands. We also don't support single row inserts.