Re: Effect of large text field data on queries

[Glen Parker <glenebob(at)nwlink(dot)com>]

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