Re: TOAST not working - Mailing list pgsql-general

From list_man
Subject Re: TOAST not working
Date
Msg-id 1149959715.15368.47.camel@vaio1linux
Whole thread Raw
In response to Re: TOAST not working  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thanks for the suggestion Tom... I'm looking into it.

To continue however and educate me on datatypes & TOAST, should a row of
10k+, in this case consisting of the datatype listed below, store OK,
when TOAST kicks in?

thanks... Angus

On Sat, 2006-06-10 at 12:28 -0400, Tom Lane wrote:
> list_man <listman@elkenserver.net> writes:
> > I have a VERY wide table and rows. There are over 800 columns of type:
> > numeric(11,2)
>
> Perhaps you should reconsider your data design.  Maybe some of those
> columns would more logically form an array?
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: TOAST not working
Next
From: Tom Lane
Date:
Subject: Re: pgxml & xpath_table