Re: Regarding Non-Default Page Sizes
>From the same posting in ids discussion group (I don't usually x-post but didn't get a response there initially :-( ): On 31 July 2012 14:19, KERNOAL STEPHENS <informixdba@gmail.com> wrote: > John Miller III covered this at one of the IIUG conferences. He said that temp > tables use the default page size no matter what. So creating your temp > dbspaces at 16K will be a waste because the temp tables will be created at the > default anyway. This was a couple of years ago and I was using version 10 at > the time. Not sure if this has changed in later versions or not. > > Kernoal > Thoughts ? If true would this also apply to system temps used for sort/merge ? Keith On 31 July 2012 12:57, Alexandre Marini <alexandre@briug.org> wrote: > Yes, you can create it in non-default pagesizes, just be careful with IO > levels, making sure your page size is available to fit all your data pages, > instead of wasting unused space, ok? > > Regards. > > Alexandre Marini > IBM Informix Certified Professional v10 / v11.50 / v11.70 > IBM Information Management Informix Technical Professional > IBM Infosphere DataStage Technical Professional > Database Administrator - Cleartech Ltda > BRIUG website administrator > Informix independent consultant > > > ________________________________ > From: art.kagel@gmail.com > Date: Tue, 31 Jul 2012 07:43:52 -0400 > Subject: Re: Regarding Non-Default Page Sizes > To: smiley73@gmail.com > CC: informix-list@iiug.org > > > Keith, > > Good questions! For me, I've never thought about it and just use default > page sizing for temp dbspaces. I'm not saying that's right, just that I > haven't done any testing and I wonder if the IBMers here have an opinion or > can report on any testing on this that was done at the labs. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > > > On Tue, Jul 31, 2012 at 6:52 AM, Keith Simmons <smiley73@gmail.com> wrote: > > I have IDS 10.00.FC5 running on Solaris 5.8 thus I have a default page > size of 2k. > > One of the table (NOT my design !!) has a row size of 1079 so I can > only get one row per page. Fragmentation is difficult so I am limited > to around 16.77 million rows and I am wasting almost half the allocated > space. > > My intention is to create some dbspaces with 8k page size, thus increasing > the > number of potential rows seven fold and significantly reducing the wasted > space > and thus I/O. > > Question is, what do I do with regard temp dbspaces. Admin Guide says all > temp > dbspaces must be the same page size, so should I make them 2k (O/S default, > current size and the same size as the majority of the dbspaces in the > database), > or 8k (same size as the new spaces). > > Is there any advantage/disadvantage either way from a performance or space > point of view ? > How does an 8k page size map down to a 2k temp dbspace page ? > How does a 2k data page map to an 8k temp page space ? > ( I think I've may have just answered this one, it doesn't matter as > it's the data that > is placed in temp not the pages so large temp pages have the same > dis/advantages as large dbspace pages and there is no conflict between data > and temp page sizes - can someone confirm ? ) > > I can find nothing relevant either online or in the documentation. > > Keith > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > > > _______________________________________________ Informix-list mailing list > Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >