Re:Just use Postgres for everything
by kolar on Saturday December 10, 2022 @02:12PM
(#33935738)
Also Postgres is too slow for large analytical databases. You need columnar database to make fast queries on >1Tb of data.
[ Parent
| on HN ]
Re:Just use Postgres for everything
by martintietz on Saturday December 10, 2022 @05:05PM
(#33937383)
As always: it depends. For some workloads something like Citus [1] might allow you stay within the PostgreSQL ecosystem even when you are trying to do OLAP.
1TB is peanuts. You can usually get by even with a lot more. Once that's expired though, you can just switch relatively easily to a different flavor of Postgres.
It's why AWS Redshift exists: Postgres with column-oriented storage.
Does anyone have experience with some postgres columnar store extension like https://github.com/citusdata/cstore_fdw
?
Re:Just use Postgres for everything
by whoopdeepoo on Saturday December 10, 2022 @03:02PM
(#33936245)
My experience was not enough support for common postgres features
Re:Just use Postgres for everything
by martintietz on Saturday December 10, 2022 @04:55PM
(#33937278)
Agree. Here is a list of the limitations: https://github.com/citusdata/citus/tree/main/src/backend/col...
AWS Redshift works wonderfully in that capacity.