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
>
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 |
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 |