Re: Column Sizes - Mailing list pgsql-general

From Tom Lane
Subject Re: Column Sizes
Date
Msg-id 27881.1068744255@sss.pgh.pa.us
Whole thread Raw
In response to Re: Column Sizes  (Adam Ruth <aruth@intercation.com>)
List pgsql-general
Adam Ruth <aruth@intercation.com> writes:
> ... It does seem that the large
> object functions do split the data into 2k chunks, but it would
> probably be a simple thing to check the source to determine if this is
> always true.  But it could always change in a future version.

My recollection is that the large object chunk size is defined as BLCKSZ/4,
so you'd get 2K with the default 8K block size, but it could also be
4K or 8K with the other likely choices for block size.

            regards, tom lane

pgsql-general by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: DOMAIN usability
Next
From: "Uwe C. Schroeder"
Date:
Subject: Re: Curious about exclusive table locks