Comment by I_am_tiberius
2 years ago
I have 2 questions.
1. Is this optimized for constantly adding and removing rows to the columnar table?
2. Is this supported by Microsoft Azure Flexible Server for Postgres?
2 years ago
I have 2 questions.
1. Is this optimized for constantly adding and removing rows to the columnar table?
2. Is this supported by Microsoft Azure Flexible Server for Postgres?
> Whenever possible, design data coming into the data warehouse as append-only. Hydra's columnar store only supports inserts. If you need to update or delete data, you will need to use row (heap) tables.
that is not the case at this point. updates, deletes, and vacuuming are all available.
That’s great! That was a quote from the docs at hydra.so if you can update them.
1 reply →
I can answer number 1:
updates and deletes are available, as well as the ability to compact the table.