Re: TOAST not working - Mailing list pgsql-general

From Christopher Browne
Subject Re: TOAST not working
Date
Msg-id 8764j83e3e.fsf@wolfe.cbbrowne.com
Whole thread Raw
In response to TOAST not working  (list_man <angus.berry@elkenserve.com>)
List pgsql-general
After a long battle with technology, angus.berry@elkenserve.com (list_man), an earthling, wrote:
> Hi,
>
> I wonder if anyone can help.
>
> I have a VERY wide table and rows. There are over 800 columns of type:
> numeric(11,2)
>
> I can create the table no problem, but when I go to fill out a full row
> with data, I get the message about reaching the 8k limit.
>
> Can someone tell me if I have to 'enable' TOAST on columns to have  it
> kick in. According to my research, numeric data types are toastable.

No, TOAST will be entirely irrelevant in this case.  TOAST allows
large columns to be moved out of the table proper.

Thus, if you had a column containing a MIME-encoded document (as is
the case when "attachments" are put into tickets in the RT3 "ticketing
system"), the Very Large Column would get moved to the associated
TOAST table.

But this will be of little assistance when no individual column is
large.

> I'd appreciate if anyone can give me lit1e.

Perhaps your schema is poorly designed, and you should consider
redesigning it.

If someone brought to me a schema consisting of 800 columns, I'd be
inclined to strike them on the head with the Elisp reference manual in
the hopes that even if it brought no enlightenment, the concussion
would discourage them from bringing it back...
--
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/nonrdbms.html
If you have a procedure with ten parameters, you probably missed some.
-- Alan J. Perlis

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Questions about indexes
Next
From: Christopher Browne
Date:
Subject: Re: TOAST not working