Mongodb or PostgreSQL? Ah, that is the question...
-
@scottalanmiller said in Mongodb or PostgreSQL? Ah, that is the question...:
@JJSagan said in Mongodb or PostgreSQL? Ah, that is the question...:
Not much to learn from my experience, since my #users/day is pathetic.
As for tdwtf, I personally don't believe it would have been faster with Mongo, but I could be wrong. I looked but unfortunately I could not find the exact benchmark chart I was referring to earlier. Nevertheless, see here: https://what.thedailywtf.com/topic/25362/so-about-that-postgresql-thing/8?lang=en-US&page=1Finally, you should consider visiting tdwtf often, the posts there are among the funniest I have ever encountered
Holy cow, I didn't realize that we were busier than them! I figured that they were the busier site. So our MongoDB is handling more traffic. Still crazy busy, though.
Aye... so now... we gots a significantly busier MongoDB based site that is substantially snappier than the only moderate to large PostgreSQL example that I am aware of. Which once again begs the question: Why?
Should be an adventure. I'll keep y'all posted
-
@gotwf said in Mongodb or PostgreSQL? Ah, that is the question...:
Might need to retract to fbsd and mongodb if that does not prove out well.
Can't find a FreeBSD package of MongoDB. Does that have a supported install?
-
@julian said in Mongodb or PostgreSQL? Ah, that is the question...:
too many variables to know for sure. They could be like us and host NodeBB on a potato server
Yeah, our NodeBB platform has some muscle behind it, and CloudFlare in front. That all helps, a lot. Our working set is 100% in RAM with loads of overhead. We always have threads idle. Although we also serve several other communities off of the same machine, it's a shared server.
-
Just an update to note that I've bailed on SmartOS and PostgreSQL due to too many bumps in the road in favor of sticking with a well supported platform. Which pretty much translates to: "what the dev heads are using...".
I use fbsd for our in house stuff that I keep updated via build server and internal lan. When I need cloud scale smartos or linux are the best options. To wit I have not even tried fbsd and pgsql so cannot weigh in there.
Thanks for all the insights. I'll probably be back to bug ya' before too long.
o/
-
Much thanks to @scottalanmiller for the advice and an embarrassing amount of hand holding. I'm now rocking an nginx tls proxied nodebb sporting Centos7, mongodb, and redis for session management.
-
@gotwf Thanks.
Sorry I was AWOL yesterday. I was in that Canton, TX tornado! Okay, not "in" it, but was in Canton when it happened.
-
-
pkg search mongodb
mongodb-tools-100.9.4 Tools for MongoDB 4.4.x and up
mongodb44-4.4.26 Distributed document-oriented "NoSQL" database (4.4.x Branch)
mongodb50-5.0.23 Distributed document-oriented "NoSQL" database (5.0.x Branch)
mongodb60-6.0.12 Distributed document-oriented "NoSQL" database (6.0.x Branch)
mongodb70-7.0.4 Distributed document-oriented "NoSQL" data