News for hackers. Stuff that matters.
Re:Never use MongoDB (2013) by fabian2k on Monday February 01, 2021 @01:55PM (#25992049)
Even without an index that sounds too long (though obviously hardware and Postgres itself both have come a long way since 2013). At 12,000 rows even a brute force query should be quick.

I would suspect something like bad statistics or some other reason that caused a pathological query plan. In any case this is not a good representation of any potential performance difference between Postgres and MongoDB.

Re:Never use MongoDB (2013) by jonstaab on Monday February 01, 2021 @01:57PM (#25992074)
I could see it taking that long if she was using a full movie database with millions of rows in it.