undefined | Better HN

0 pointscpursley2y ago0 comments

Postgres does all that plus 100x.

0 comments

tgv2y ago

I've also tried SQLite, but they didn't do large documents that well. And the project was started before I was aware Postgresql had json support.

But what's the advantage of Postgresql in this case?

winrid2y ago

But the horizontal scaling is easier with Mongo than Citus.

yawaramin2y ago

But you don't need to horizontally scale if you use a beefy Postgres instance. Horizontal scaling is a problem created by using an inefficient DB in the first place.

winrid2y ago

I have DB clusters with masters with a terrabyte of ram. Going beyond that is a PITA with warming up cache, backups, and so on. There is a reason there's a huge industry for shared databases.

Also, query for query, Mongo isn't going to be that much slower than PG, and faster for some usage patterns...

1 more reply

j / k navigate · click thread line to collapse

0 comments

tgv2y ago

I've also tried SQLite, but they didn't do large documents that well. And the project was started before I was aware Postgresql had json support.

But what's the advantage of Postgresql in this case?

winrid2y ago

But the horizontal scaling is easier with Mongo than Citus.

yawaramin2y ago

But you don't need to horizontally scale if you use a beefy Postgres instance. Horizontal scaling is a problem created by using an inefficient DB in the first place.

winrid2y ago

I have DB clusters with masters with a terrabyte of ram. Going beyond that is a PITA with warming up cache, backups, and so on. There is a reason there's a huge industry for shared databases.

Also, query for query, Mongo isn't going to be that much slower than PG, and faster for some usage patterns...

1 more reply

j / k navigate · click thread line to collapse