3 ms·

And even if you want to stay in the Postgres ecosystem there's options for you there.

• gregw2 3y ago
  For analytics, use a columnar database. There are even other AWS Postgres-oriented options (check the pricing first): ZeroETL from Aurora Postgres to (postgres-compatible) Redshift (Serverless?)
  • Moto7451 3y ago
    Yup. Even gross abuses of Redshift run fine with appropriate roll ups and caching. At a past job we did it “wrong enough” that it took a while for a more state of the art solution to catch up. This is not to say the abuse of Redshift should have been done, but AWS has been abused a lot and the engineers there have found a lot of optimizations for interesting workloads. But to pick the wrong DB tool in the first place and bemoan it as “not scalable” is a bit like complaining that S3 made for a poor CDN without looking at how you’re supposed to use it with Cloudfront.
  • okr 3y ago
    Is ZeroETL not in early stages, still? I heard it replicates everything. No filtering yet on parts of the binlog (tables/columns). But other than that, i like the idea. (I would like to know, where their ZeroETL originated from, usually AWS picks up ideas somewhere and makes it work for their offerings to cash in. A universal replication tool.)