undefined | Better HN

0 pointsiknownothow2y ago0 comments

The problem is, which "database"? If you know the data is always going to be in the range of ~1TB, use Postgres or some other ACID database. But I don't know of any petabyte scale ACID compliant database.

Also I'm not sure if ACID is sufficient or not for banking systems.

0 comments

ZeroCool2u2y ago

BigQuery is ACID compliant and easily handles petabytes.

https://cloud.google.com/bigquery/docs/introduction

89vision2y ago

Nobody in their right mind is using BQ for oltp workloads

ibains2y ago

Yes, but in addition to being ACID compliant (serializable ANSI), you need to support a million transactions per second - it’s not just about data size.

moneywoes2y ago

What’s the cloud infra like?

sjdmdlakziggy2y ago

Generally speaking, you won't find financial institutions using Postgres for core line of business databases.

joeblubaugh2y ago

What will they be using? A similar SQL database that has a big vendor behind it like Oracle, or something else?

chaxor2y ago

Any database easily handles terabytes, idk why that's a condition.

DuckDB and SQLite easily handle terabytes of data. They're just not so much for cloud based apps, or things that need multiusers and access control junk. They're the best choice for just about everything else though.

j / k navigate · click thread line to collapse