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