Thanks bunches, guys. Appreciated.
Trawling the web it seems Mongodb has been loosing some of it's shine over the past couple years, with some fairly high profile sites switching over to pgsql since it now supports jsonb. For example:
Since The Guardian IS document centric, I suspect MongoDB must have been causing quite substantial amount of grief.
The impetus for such seems to generally stem from scale and maintenance related issues.
Then there is performance, which definitely counts in my book, but NOT at expense of reliability, maintainability, and security. To wit, I've also trawled the NodeBB forums at mongolassi and dailywtf sites. Former is pretty snappy from my workstation whilst the latter has about twice the lag (and I'm being generous here). Maybe hardware or network related, as I've yet to investigate either beyond a bit of clickery:
The Guardian is using AWS's proprietary enhanced PostgreSQL, however, so I'd really love to hear from the daily what the fsck now that they've been on pgsql for a while (as I presume they're not using aws?).
I figured I'd start with Mongo, as there's a postgres converter and hence offers opportunity to switch on down the road, but having outstanding issues since Dec. of 2018, sans any developer response whatsoever raises my eyebrows a bit:
Yes, I know I need to do my own testing but .... I also don't want to invest time and effort repeating what others have already grokked, but maybe not communicated. Not really all that lazy - more impatient to get this latest project online and don't want to delay a couple weeks torture testing each.
Thanks again for your insights.