News for hackers. Stuff that matters.

A comment on Citus Cloud 2, Postgres, and Scaling Without Compromise. Parent comment

Re:Citus Cloud 2, Postgres, and Scaling Without Compromise by qaq on Thursday November 16, 2017 @06:18PM (#15717592)
3TB? even on crap option like RDS up to 6TB is OK. You can get generic box with 200+ cores (actual cores not vCPUs) and 12TB of RAM from SuperMicro.
[ Parent | on HN ]
Re:Citus Cloud 2, Postgres, and Scaling Without Compromise by doh on Thursday November 16, 2017 @06:22PM (#15717616)
You can go to as high as the box allows you to go (GCE allows I believe up to 10TB per server), but the performance will suffer.
[ Parent | on HN ]
Re:Citus Cloud 2, Postgres, and Scaling Without Compromise by chucky_z on Thursday November 16, 2017 @10:52PM (#15718758)
I would add the caveat that it depends on your data heavily.

I supported a 20TB single-node DB, and it worked just fine. We had a lot of cold data though (about 10TB of it was solely for historical records, and 9.5TB of the rest was only accessed 4x yearly for massive reports).

The hardest part was never postgresql, mainly in numa related stuff.

[ Parent | on HN ]