Citus Unforks from PostgreSQL, Goes Open Source

Re:Citus Unforks from PostgreSQL, Goes Open Source by flavor8 on Thursday March 24, 2016 @03:26PM (#11355672)

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?

[ Parent | on HN ]

Re:Citus Unforks from PostgreSQL, Goes Open Source by lfittl on Thursday March 24, 2016 @05:09PM (#11356466)

Copying from https://github.com/citusdata/cstore_fdw#usage

  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.

So I think you can certainly mutate tables, but the focus is on bulk-inserts, rather than individual append actions.

[ Parent | on HN ]