2 ms·
Oh yes, that annoying problem (especially fro MongoDB) that data should eventually be committed to a disk.) Informix (and PostgreSQL) allows DBA to choice "che
by dschiptsov 13y ago
Oh yes, that annoying problem (especially fro MongoDB) that data should eventually be committed to a disk.)
Informix (and PostgreSQL) allows DBA to choice "checkpoint/vacuum intervals".
The rule of thumb, unless you are a Mongo fan, is that checkpoints should be performed often enough to not take too long, which depends only on the actual insert/update data flow.
But any real DBA could tell the same - sync quickly, sync often, so server will run smoothly, but not "at web scale" and the pain of recovery will be less severe.)