Improved Out of the Box Defaults
Ingres has new defaults for the following configuration parameters, set during installation.
The default page size (default_page_size) for tables is changed from 2K to 8K.
The default buffer cache size (cache_guideline) is configured as medium for all page sizes, resulting in increased size for the following page sizes:
• For 8K page size, increased from 16 MB to 48 MB.
• For 32K page size, increased from 12 MB to 48 MB.
• For 64K page size, increased from 11 MB to 48 MB.
DMF Cache 2K and 8K are enabled by default.
The default transaction log file size (II_LOG_FILE_SIZE_MB) is changed from 32 MB to 256 MB. The required minimum log file size is increased from 16 MB to 32 MB.