News for hackers. Stuff that matters.

A comment on Amazon DocumentDB, with MongoDB compatibility. Parent comment

Re:Amazon DocumentDB, with MongoDB compatibility by kstrauser on Wednesday January 09, 2019 @07:33PM (#18870494)
A recent work Slack chat had a dev asking what a particular table contained. They were going through our data inventory and found a randomly-named table 18TB in size. When I ran "select count()" against it, I got back 5,325,451,020,708 rows (that's a copy-and-paste).

50GB isn't trivial, but it's utterly manageable.

[ Parent | on HN ]
Re:Amazon DocumentDB, with MongoDB compatibility by Aeolun on Wednesday January 09, 2019 @07:37PM (#18870511)
It seems a bit wrong if you have a 18TB table but no idea what it contains...
[ Parent | on HN ]
Re:Amazon DocumentDB, with MongoDB compatibility by kstrauser on Wednesday January 09, 2019 @07:47PM (#18870555)
It was a temp table that we hadn't garbage collected yet. We don't make a habit of leaving that much junk data around, but it bumped our monthly storage bill several percent, not like tripled it.
[ Parent | on HN ]
Re:Amazon DocumentDB, with MongoDB compatibility by apta on Thursday January 10, 2019 @07:44PM (#18880022)
Was this a relational or NoSQL DB?
[ Parent | on HN ]
Re:Amazon DocumentDB, with MongoDB compatibility by kstrauser on Monday January 14, 2019 @01:31PM (#18905134)
It's primarily in things like Spark and Snowflake that act like relational DBs as long as you squint the right way.
[ Parent | on HN ]