[Info-ingres] 4k Cache

[Martin Bowes]

Hi Steve,

Catalogs are typically 8k, but this would be version dependent. You can find out for sure by querying iitables.

select distinct table_pagesize from iitables\g

It's certainly reasonable to reduce the 2k cache and expand the 8k in its place, but you may like to monitor with dm420 to get some cache usage stats before going wild.

Martin Bowes

-----Original Message-----
From: Steve <s.anderson.au at gmail.com> 
Sent: 09 September 2021 15:15
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] 4k Cache

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  
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres