Re:PostgreSQL 9.6 Beta 1 Released
by gshulegaard on Thursday May 12, 2016 @01:29PM
(#11685203)
Yes and no. Take the following with grain of salt as it is just my personal opinion/understanding. Only 1 or 2 points are actually from challenges I have run into.
Restricting every query to a single core places an artificial CPU cap on a system that would otherwise be IO capped.
As analytics keeps gaining popularity, the need/desire to move more and more CPU bound processing to the data storage layer is increasing.
And finally, PostgreSQL's advanced query planning/partitioning support would immensely benefit from being able to split partition queries into multiple process buckets.
Restricting every query to a single core places an artificial CPU cap on a system that would otherwise be IO capped.
Disks/storage is also getting faster (http://www.geek.com/chips/new-intel-storage-is-1000-times-fa...).
As analytics keeps gaining popularity, the need/desire to move more and more CPU bound processing to the data storage layer is increasing.
And finally, PostgreSQL's advanced query planning/partitioning support would immensely benefit from being able to split partition queries into multiple process buckets.