big data: Postgres @AWS: EC2 better than RDS, Aurora

 Why Postgres RDS didn’t work for us (and why it won’t work for you if you’re implementing a big data solution) | by Max Kremer | Jan, 2024 | Medium

"...don’t use a managed database services and roll our own infrastructure on EC2.

The WRITE node could be slow, it’s only ingesting data, so EBS was good enough but we were able to DOUBLE EBS throughput using ZFS with compression.

$11K bill down to a $2100 (projected for September which will the first full month we’re clear of any RDS baggage)"