RE: Pagesize question
Colin Bull said Tru64 uses 8K pages while Informix uses 2K pages, possibly configurable from 9.5. rkusenet asked why configurable page size was dropped after 5.0 and brought back. Madison Pruet said the old size was fixed per instance and problematic, long rows replaced the need, and larger pages support wider index keys. Jonathan Leffler recalled the old ONCONFIG page-size parameter could not safely be changed.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
DeeWee wote > > we are using informix 7.31 FC6 and unix tru64 5.1b > > unix pagesize command tells 8192 > onmonitor shows Page Size 2 Kbytes > > if informix uses pages, what size are they? > They are not the same. Tru 64 uses 8K pages. Informix uses 2k pages. (This might be configurable from version 9.5.) Colin BUll _______________________________________________________________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. _______________________________________________________________________ sending to informix-list
"Colin Bull" <Colin.Bull@videonetworks.com> wrote in message news:1103555424.ba92a5a91f967bc36e16f51fc315af7c@teranews... > > DeeWee wote > > > > we are using informix 7.31 FC6 and unix tru64 5.1b > > > > unix pagesize command tells 8192 > > onmonitor shows Page Size 2 Kbytes > > > > if informix uses pages, what size are they? > > > > They are not the same. > > Tru 64 uses 8K pages. > Informix uses 2k pages. (This might be configurable from version 9.5.) hmm interesting. Informix use to have configurable page size till version 5.0. Why did they stop it? And .. why are they bringing it back now.
"rkusenet" <rkusenet@sympatico.ca> wrote in message news:32o8quF3mv04oU1@individual.net... > > "Colin Bull" <Colin.Bull@videonetworks.com> wrote in message > news:1103555424.ba92a5a91f967bc36e16f51fc315af7c@teranews... > > > > DeeWee wote > > > > > > we are using informix 7.31 FC6 and unix tru64 5.1b > > > > > > unix pagesize command tells 8192 > > > onmonitor shows Page Size 2 Kbytes > > > > > > if informix uses pages, what size are they? > > > > > > > They are not the same. > > > > Tru 64 uses 8K pages. > > Informix uses 2k pages. (This might be configurable from version 9.5.) > > hmm interesting. Informix use to have configurable page size till version 5.0. > Why did they stop it? And .. why are they bringing it back now. > >
"rkusenet" <rkusenet@sympatico.ca> wrote in message news:32o8quF3mv04oU1@individual.net... > > "Colin Bull" <Colin.Bull@videonetworks.com> wrote in message > news:1103555424.ba92a5a91f967bc36e16f51fc315af7c@teranews... > > > > DeeWee wote > > > > > > we are using informix 7.31 FC6 and unix tru64 5.1b > > > > > > unix pagesize command tells 8192 > > > onmonitor shows Page Size 2 Kbytes > > > > > > if informix uses pages, what size are they? > > > > > > > They are not the same. > > > > Tru 64 uses 8K pages. > > Informix uses 2k pages. (This might be configurable from version 9.5.) > > hmm interesting. Informix use to have configurable page size till version 5.0. > Why did they stop it? And .. why are they bringing it back now. 1) the configurable page size that we had was fixed within the instance. There were a lot of problems with its implementation. We added the support for long rows - where the row spanned multiple pages to remove its need. 2) so that we can support wider index keys. > >
rkusenet wrote: > hmm interesting. Informix use to have configurable page size till version 5.0. > Why did they stop it? And .. why are they bringing it back now. Until some stage (I thought it was 6.00, but I am willing to believe it was 5.00), the ONCONFIG (or TBCONFIG) file contained a parameter which was the page size, but you could not alter it -- if you did, all hell broke loose one way or another. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/