From: | Kenneth Been <been(at)cs(dot)nyu(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | large object minimum storage |
Date: | 1999-06-27 01:25:39 |
Message-ID: | Pine.GSO.4.10.9906262112340.8739-100000@slinky.cs.nyu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-06-27 02:19:17 | Re: [GENERAL] large object minimum storage |
Previous Message | Adam Haberlach | 1999-06-26 18:03:20 | Re: [GENERAL] What does this mean ? |