Re: [GENERAL] large object minimum storage

6.5 I think uses less space, but it still has to be a multiple of 8k
blocks.

> Do large objects have to be at least 16K, plus 16K for the index, even if
> the object is much smaller?
>
> I have a bunch of large objects of widely varying size. Most are quite
> small, but a few are above the 8K limit, so I thought I might just store
> them all as large objects. But this was taking up far too much space, and
> I noticed that the xinv* and xinx* files were all 16K, which is much more
> than most of them need.
>
> Is this a configuration parameter? I didn't see anything in the
> documentation. (I am currently using 6.3.2 on Redhat linux 5.2.)
>
> I've pretty much decided to use arrays instead of blobs, and put the
> "overflow" in a separate table for the few objects that exceed the limit,
> but if anyone has any better ideas, I'd love to hear them.
>
> Thanks
>
> Ken
>
>
>
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026