Re: Effect of large text field data on queries - Mailing list pgsql-general

Tom Lane wrote:
> Glen Parker <glenebob@nwlink.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