Variable page sizes

At 09:39 AM 3/18/98 -0500, Lucky Leavell wrote:

>Well, I have OI2.0 up and running and am getting ready to migrate my data
>from OI1.1.  I was wondering about trying, say, a 4K page size at least on
>some user tables as several of the new features (e.g., row level locking)
>are only available for larger page sizes. ...

I've been experimenting with using 2k and 8k pages.  So far, I've used
8k pages mainly for intermediate temp tables.  The results so far are
encouraging.  In one test which did a fair amount of temp table flailing
with reasonably wide rows (such that only 1 row per page fit on a 2k page),
I can speed things up by over 1/3 just by using 8k pages.  YMMV of course
but it's a good start.

So far I have not heard of many bugs related to large pages, in the
9712 release.  I would counsel caution, though; I'm not sure I would move
my key transaction tables to >2k yet without some pretty extensive
testing, including crash/recovery testing.  Maybe in a few weeks after
some more production sites have beat up 2.0/9712 a bit.

Karl R. Schendel, Jr.
K/B Computer Associates   schendel@kbcomputer.com
Ingres and Unix Expertise

NAIUA Member-At-Large     atlarge@naiua.org


Lucky,

  Make sure you run GenLevel 9712 + patches or you will encounter some
"interesting" problems with cursors and larger page sizes.  3GL/4GL 
programs using cursors will fail with GCA errors where the terminal 
monitor (which uses select loops) will function just fine on the same
query.

Cheers,

Michael Leo            mleo@cariboulake.com        mal@visi.com
Caribou Lake Software  http://www.cariboulake.com  Java/RDBMS/Ingres Solutions
St. Paul, Minnesota    (612) 323-9713
Ingres Q & A
Back to William's Home Page
Email William