Re:Postgres 9.2 will feature linear read scalability up to 6...
by jeltz on Tuesday April 03, 2012 @07:19PM
(#3795310)
The bulk of the fixes were in the locking in PostgreSQL though, and before those fixes were made the llseek problem did not appear to many since in almost all cases people hit a bottleneck in the PostgreSQL code before hitting the Linux Kernel one.
Re:Postgres 9.2 will feature linear read scalability up to 6...
by gauravk92 on Monday April 09, 2012 @04:47PM
(#3819152)
Thank you! Do you have any experience with CouchDB? I'm sure you've at least of heard of erlang and all the benefits it promises, I'm considering whether to use it for a future project, I might because the JSON REST api seems convenient to use without having to worry about scale. But I haven't done testing and could use advice.
This kind of performance optimization isn't new, concurrency is the name of the game. Erlang is a language built around concurrency and it has some databases written in it (couchdb) that scale with more cores due to erlangs inherent capabilities. So has this kind of performance increase been seen before, yes.