3 ms·
On disk we have just a "stupid" dump that we reload a startup. In a lazy fashion, or not? That is, if I have a 10GB data set, will I be either waiting X minute
by petercooper 18y ago
On disk we have just a "stupid" dump that we reload a startup.
In a lazy fashion, or not? That is, if I have a 10GB data set, will I be either waiting X minutes for a basic restart or dealing with sluggish queries for a slightly lesser time?
(Update for anyone who wants an answer too: I dug around the docs and found that it's a full read into memory on restart, not lazy loading. They give an example of "It takes about 45 seconds to restore a 2 GB database on a fairly standard system, no RAID." So if frequent restarts are in your plan for some reason - not that they should be, of course - it might not be a goer.)