lazy_writes

[buffers]
lazy_writes=system dependent value

If this value is non zero "lazy writing" is enabled, which means that during periods of relative inactivity the database manager will ensure all cached information is gradually written out to disk.

This value has DP4 release specific behaviour.

Release 4.620,4.621,4.525

On operating systems for which we support asynchronous file I/O (currently Windows NT,Windows 2000, and Windows XP) the number is the maximum number of lazy disk writes that may be simultaneously in progress, and the actual default value depends on the value of max_pending. For other operating system only one write can be in progress, so any non zero value is treated as 1.

For systems which are constantly heavily loaded (for example where there is a program that continually polls the database) it may be beneficial to completely disable "lazy writing". You should probably also set this option to 0 if you set buffers to a value of 32768 or above. With buffers=16384 lazy writing is likely to be beneficial. With buffers=65536 lazy_writing causes a severe performance degradation.

Release 4.622,4.526

On operating systems for which we support asynchronous file I/O (currently Windows NT,Windows 2000, and Windows XP) the number is the maximum number of lazy disk writes that may be simultaneously submitted, and the actual default value depends on the value of tracksize. For other operating systems only one write can be in progress, so any non zero value is treated as 1.

In release 4.622 lazy writing should not normally be disabled.