2009/2/5 David Wall
>
>
>
>
>> Are the BYTEA fields stored in the same table as the rest of the data?
>
>
> yes - and the TOAST tables if it's larger than 1/3 of a page or so. search
> for TOAST details if you're interested.
>
> Hmm... So a page is 8192 bytes, and it leaves your regular table an
Thanks, Filip.
If I have an "unlimited" number of name-value pairs that I'd like
to get easy access to for flexible reports, could I store these in
two arrays (one for name, the other for value) in a table so that
if I had 10 name-value pairs or 200 name-value pairs, I could
2009/2/4 David Wall
>
> First, LOs seem to allow an OID column to be added to any number of tables,
> but is it true that the actual large object data is stored in a single table
> (pg_largeobject?).
yes.
http://www.postgresql.org/docs/8.3/static/lo-intro.html
> If so, wouldn't this become
In article <4989e659.3000...@computer.org>,
David Wall writes:
> If I have an "unlimited" number of name-value pairs that I'd like to
> get easy access to for flexible reports, could I store these in two
> arrays (one for name, the other for value) in a table so that if I had
> 10 name-value pair
