Comment by codesnik
2 days ago
ah, of course it have been discussed already https://discuss.rubyonrails.org/t/proposal-adding-postgres-p...
2 days ago
ah, of course it have been discussed already https://discuss.rubyonrails.org/t/proposal-adding-postgres-p...
Yes, the need isn't exactly the same. `load_async` use case if for known slow-ish queries, hence for which you want actual parallelization on the server.
Since that discussion on the forum, I talked more about pipelining with some other core devs, and that may happen in some form or another in the future.
The main limiting factor is that most of the big Rails contributors work with MySQL, not Postgres, and MySQL doesn't really have proper pipelining support.
re: MySQL, strictly speaking, that isn't true; proper pipelining was introduced starting in MySQL 5.7, ten years ago. However it requires using the newer "X Protocol", which isn't widely supported by third-party drivers, nor is it supported in MariaDB. So adoption has been poor.