[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