[Info-Ingres] Time to say goodbye to the 2k page size?

Roy Hann specially at processed.almost.meat
Thu Oct 25 16:33:47 CDT 2007


"Chip Nickolett" <chip.nickolett at gmail.com> wrote in message 
news:1193283664.370576.194330 at k35g2000prh.googlegroups.com...
>I personally look at page sizes as rules of thumb rather than blanket
> generalizations, and then make the appropriate decisions based on your
> specific environment.

Good point.

Which reminds me, iitables.tups_per_page seems wrong (in 9.1.0 
(int.w32/119)).  For instance if you have a table with just a CHAR(1) NOT 
NULL column using 2kb pages, the reported value of tups_per_page is 670 
(>>2**9).

Roy

PS: No smart-alec comments about the logical maximum number of key values in 
that table.  This is SQL.  Anything goes. 




More information about the Info-Ingres mailing list