| (Marco from Citus Data) > If I use CitusDB as an analytical database, then it's comparable with Redshift, Hive etc. A particular difference is in response times and concurrency. Data warehouses and Hive are great for reporting use-cases, but not for use-cases that require fast responses and have many users like analytical dashboards. This is a use-case for which Citus is particularly well-suited (see for example the CloudFlare dashboard). > Can I use cstore_fdw in CitusDB and able to take advantage of real-time nature of Postgresql? Yes, since cstore_fdw and Citus are both developed by Citus Data we made sure they're fully integrated. We've even seen some deployments that use a mixture of columnar- and row-based storage in a single distributed table. We find that row-based storage generally has better ingestion performance and more indexing possibilities. Citus can do very fast execution of analytical queries by parallelizing over row-based shards and using the indexes on each of them. However, if you only need a small number of columns and have analytical queries that are not very selective, you can use columnar storage just as easily and even mix and match (might require some support). > I guess another use case is using CitusDB as distributed data store Yep, Citus can definitely be used for that by using hash-partitioned tables. |