Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the biggest table size they can have under ingres 2.5 or later on 64 bit Unix Operating Systems (e.g. TRU64, AIX 64 bit, Solaris 8)?

April 26, 2017biggest bit ingres later Operating Systems size Table Unix

0

Posted

What is the biggest table size they can have under ingres 2.5 or later on 64 bit Unix Operating Systems (e.g. TRU64, AIX 64 bit, Solaris 8)?

1 Answer

0

Posted

In a 64 bit O/S, a file can potentially hold up to 9 trillion bytes, presuming that the Operating System has implemented full 64 bit addressing. Ingres 2.6 is still using 32 bit addressing, 8,388,608 (2 to the 23rd power) pages in an ingres table, maximum rows per page is: 512 (2 to the 9th). So the absolute maximum number of rows in an ingres table is 4,294,967,296. Depends on the length of each row, and the size of the page (up to 64 kb).