3 ms·
Database noob here: Could someone please explain why this is different from other approaches and why this is interesting? How does it compare to BigQuery on GCP
by theCricketer 10y ago
Database noob here: Could someone please explain why this is different from other approaches and why this is interesting? How does it compare to BigQuery on GCP or Elasticsearch? Are those even the right comparisons?
Is this interesting because they use Postgres?
- ddorian43 10y agoElasticsearch can't do very complex queries like postgresql can (probably needs something like spark?). Elasticsearch can't grow tables, you need to create a new one index with more shards and transfer data. BigQuery works only in column-store while citus works in column-store + row-store (column-stores don't support update/delete). You can mix row/column-store tables and query/join them together. It is interesting because that it's latest postgres, example you can have Hyperloglog column-types, which ~none else offers. It is available as open-source wich bigquery isn't (elastic is though).