[Info-ingres] 4k Cache

[Steve]

God willing, as mentioned above, I plan to increase the page size of all user tables and indexes to 8k and 4k, respectively. Currently both are 2k. This was a recommendation by Actian.

A small portion of the tables are already 8k; that being the default page size.

Upon making these changes, I was thinking of reducing the 2k buffer cache by 75%, as the only 2k tables at that point would be the system catalogs (I think they’re 2k) and possibly the odd users’ own private tables. I figured the memory saved could be reallocated to the 8k cache. Is that a reasonable idea?

Steve