3 ms·
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 Serve
by I_am_tiberius 3y 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?
- gregwebs 3y ago> 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.
- jerrysievert 3y agothat is not the case at this point. updates, deletes, and vacuuming are all available.
- gregwebs 3y agoThat’s great! That was a quote from the docs at hydra.so if you can update them.
- jerrysievert 3y agoI put in a PR as soon as I saw your note. I dunno if it auto updates from there.
- jerrysievert 3y agoI can answer number 1: updates and deletes are available, as well as the ability to compact the table.