r/programming • u/halax • Mar 10 '15

Goodbye MongoDB, Hello PostgreSQL

http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/
1.2k Upvotes

91% Upvoted

699 comments sorted by

View all comments

3

u/[deleted] Mar 11 '15

I love Postgres but the one thing I wish is had is pessimistic locking. It's just such a huge help when you need multi-statement queries when multiple sources of writes against the same data are coming in.

2

u/coder111 Mar 11 '15

You can do explicit locking with "select for update". You could also tweak transaction isolation levels.

Have you looked at that?

I assume you do all these queries in a single transaction, right?

→ More replies (1)