Re: request for enhancement: 2K -> 4K

In article <3494a300.1118117@news.xs4all.nl>, Reinoud van Leeuwen <reinoud@xs4all.nl> writes >On 12 Dec 1997 09:26:16 -0700, Pablo Sanchez <pablo@sgi.com> wrote: > >>Sybase Inc., >> >>I'd like to request that we increase the atomic page size >>from 2K to 4K. Today's systems I/O subsystems can handle >>the larger page sizes. It'd be nice to have pages greater >>than 2K for DSS type of applications. OLTP, I don't >>believe, would suffer. (Informix uses a 4K page size and >>they do pretty well...) with DSS app's, one has >>denormalization that tends to create fat rows... how about >>it? > >The disadvantage is that 4 K will be the minumum size for all >allocations, resulting in more wasted space in the database... >_______________________________________ With 2Gb (2048Mb) even wasting 20Mb is only 1%! Surely you don't size things that 1% more will mean you need to buy another disk? I come from tge Informix side and I'd like things similar to Informix's blobspaces. You have normal database spaces which have 2K or 4K pages depending upon the specific port. within blobspaces you then define how large a blobpage will be in units of either 2K or 4K. Big buffers (up to, I think 32K) are using to access blobspaces. Why can't we just define our own page sizes for each area of disk we use? Say in units of 2K or 4K depending upon the machine type? >___________ >Reinoud van Leeuwen reinoud@xs4all.nl >http://www.xs4all.nl/~reinoud >I specifically DO NOT give anyone permission to use my email adress >for any commercial or non commercial mailings. I will bill everyone >who sends me this kind of mail for wasting my time. Under Dutch law, >people who don't let me know they disagree with such a bill are obliged >to pay it. >Attention: remove extra anti-spam info at end of reply adress -- David Williams