Re: [HACKERS] How to turn off TOAST on a table/column - Mailing list pgsql-general

From Tom Lane
Subject Re: [HACKERS] How to turn off TOAST on a table/column
Date
Msg-id 29208.1006898912@sss.pgh.pa.us
Whole thread Raw
In response to How to turn off TOAST on a table/column  (Barry Lind <barry@xythos.com>)
List pgsql-general
"Ross J. Reedstrom" <reedstrm@rice.edu> writes:
>> would suffice to disable toasting of all columns in 'mytable'.

> This would reimpose the max-tuple limit on that table, would it not?
> So trying to store 'too large' a text would error?

Right.  Presumably, that's what Barry wants to test.  In practice the
other values are more likely to be useful (for toastable datatypes
that is).

>> See src/include/pg_attribute.h for documentation of the allowed values
>> for attstorage.

> This needs to get into the admin docs. I suppose it's also waiting on the
> ALTER TABLE interface.

Yeah.  Right now it's too easy to shoot yourself in the foot (for
example, you mustn't set attstorage to anything but 'p' for a
non-varlena datatype).  So we haven't wanted to document the
UPDATE-pg_attribute approach.

            regards, tom lane

pgsql-general by date:

Previous
From: "John Gray"
Date:
Subject: Re: How to turn off TOAST on a table/column
Next
From: Sean LeBlanc
Date:
Subject: Some application questions