6 ms·
I'm very interested to hear some of the details about how the storage engine was ported to Linux. One of the advantages of SQL Server was how well it exploited
by dhd415 11y ago
I'm very interested to hear some of the details about how the storage engine was ported to Linux. One of the advantages of SQL Server was how well it exploited the Windows overlapped I/O model for disk access. When running large selects, backups, or restores, SQL Server always uses the full bandwidth of my disk subsystem. When I built a prototype of my application on PostgreSQL (which I would much rather run for its free licenses and more mature indexing), I had to tweak all kinds of things to get it to use the full bandwidth of my disk system and I was not always successful.
- deleted 11y ago[deleted]
- _wmd 11y agoIt's not difficult to mimic overlapped IO using a thread pool, and not that much less efficient either, assuming the pending request count is quite low
- ajross 11y agoThe space of applications for which storage bandwidth is a limit on performance but where the overall scale is appropriate for a SQL RDBMS is shrinking every year. Is this even a meaningful niche? Basically, http://yourdatafitsinram.com/ http://yourdatafitsinram.com/