New answers tagged architecture
I suppose you could write the information directly to the redo log at each modification, but that would mean a lot of very small 'write' operations on disk. If you cache this instead you can at least wait the next 'COMMIT' and do less 'writes'. In my experience this buffer does not need to be very large because of this, on a typical system COMMITs will ...
Top 50 recent answers are included