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