3 ms·
I really appreciate how they have separated the computational layer from data storage. Want to do a massive pre-calculation without disturbing others? Run it in
by nikonyrh 5y ago
I really appreciate how they have separated the computational layer from data storage. Want to do a massive pre-calculation without disturbing others? Run it in a separate warehouse.
Also the underlying copy-on-write datastructure is a timesaver, you can clone (like taking a backup & restoring it but with a new name) a 100 GB database in a few tens of seconds or minutes. Also if you run an UPDATE and forgot to include a WHERE clause you can retrive the old data via time travel. You can execute queries directly to an older version of the table (or database) without having to restore it from a backup!
There is an about 500 ms overhead for each query, so it isn't suited for all use cases though.