On Fri, May 3, 2013 at 12:09 AM, Andres Freund <and...@2ndquadrant.com> wrote: >> But that brings up an interesting question. How hard / feasible would it be >> to add DIO functionality to PG itself? > > I don't think there is too much chance of that - but I also don't really > see the point in trying to do it. We should start by improving postgres > buffer writeout which isn't that great, especially with big shared > buffers. We would have to invest quite a lot of work in how our > buffering and writeout works to make DIO perform nicely.
I think eventually we'll probably go that route. Double-buffering is just too expensive not to solve one way or the other. The other is using mmap and somehow solving the WAL ordering issue which would be nice but seems even less likely to succeed. The problem with DIO which has been covered many times in the past here is that then we need to learn a lot about the hardware. It would be up to us to schedule i/o efficiently for the hardware layout which is not an easy problem especially if we're not always the only consumer of that hardware bandwidth. I don't think it's worth going through the discussions again unless someone is actually interested in writing the code and has new ideas on how to solve these problems. -- greg -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers