Tom Lane wrote:
Glen Parker <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/

Reply via email to