Re: TOAST not working

From: list_man <listman(at)elkenserver(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: TOAST not working
Date: 2006-06-10 17:15:15
Message-ID: 1149959715.15368.47.camel@vaio1linux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs 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(at)elkenserver(dot)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
>

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Christopher Browne 2006-06-10 21:10:06 Re: TOAST not working
Previous Message Tom Lane 2006-06-10 16:28:18 Re: TOAST not working

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-06-10 18:06:01 Re: pgxml & xpath_table
Previous Message Tom Lane 2006-06-10 16:28:18 Re: TOAST not working