On 01/13/2014 11:22 PM, James Bottomley wrote: > >> The less exciting, more conservative option would be to add kernel >> interfaces to teach Postgres about things like raid geometries. Then >> Postgres could use directio and decide to do prefetching based on the >> raid geometry, how much available i/o bandwidth and iops is available, >> etc. >> >> Reimplementing i/o schedulers and all the rest of the work that the >> kernel provides inside Postgres just seems like something outside our >> competency and that none of us is really excited about doing. > This would also be a well trodden path ... I believe that some large > database company introduced Direct IO for roughly this purpose. > The file system at that time were much worse than they are now, so said large companies had no choice but to write their own.
As linux file handling has been much better for most of active development of postgresql we have been able to avoid it and still have reasonable performance. What was been pointed out above are some (allegedly desktop/mobile influenced) decisions which broke good performance. Cheers -- Hannu Krosing PostgreSQL Consultant Performance, Scalability and High Availability 2ndQuadrant Nordic OÜ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
