[Info-Ingres] How can I check used page size for one row

[martin.bowes at ctsu.ox.ac.uk]

Hi  labartez,

The simplest way is to use 'with fillfactor=1' in the modify statement.
This doesn't absolutely garuntee one row per page, but it'll gop close in 
most circumstances.

The alternative is to add a wide column of nothing to the table so that 
each row can occupy only one page, regardless of the fill factor. This 
works because the row must not span a page. So making the row width 
say 1100 characters in a 2k page will ensure 1 row per page. Make 
obvious adjustments for other page sizes.

To see how many rows per page you are getting. The row tid contains 
its page and row number. In a 2K page, mod(tid,512) is the row number 
and tid/512 is the page number. For a 4k page use 256, 8k use 128 
etc...

Martin Bowes

> Hello Guys
> 
> I want to separate rows by pages.
> One row per page.
> 
> Do You know have can I check page size used by one row?
> 
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres at kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>