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 <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
