Tom Lane wrote:
> Glen Parker <glenebob(at)nwlink(dot)com> writes:
>> How much of a TOAST'd field is actually stored in the main heap table?
>> Is there a way to configure that amount?
>
> A pushed-out-of-line value is replaced by a 20-byte pointer structure.
> There's no such thing as partially out-of-line. See
> http://www.postgresql.org/docs/8.1/static/storage-toast.html
Ah, thanks. I think possibly changing the storage on this field may
help some (I will gladly trade storage space for speed). How can I
determine the default storage type for a given TOASTable data type (text
in this case)?
-Glen