News for hackers. Stuff that matters.
Re:Asynchronous Python and Databases by laurencerowe on Sunday February 15, 2015 @10:10PM (#9055124)
Postgres lets you synchronize snapshots across connections so that they all see the same data (though subsequent changes are not visible to the other transactions unless you export another snapshot.) http://www.postgresql.org/docs/9.4/static/functions-admin.ht...

This lets you parallelize work across multiple processes while maintaining consistency. When the client is the limiting factor you can use this with multiprocessing. When the db server is the limiting factor you can just use threads (or async.) Postgres backend processes are essentially single threaded.

There are no comments on this comment yet.