From: list_man <listman@elkenserver.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@postgresql.org
Subject: Re: TOAST not working
Date: Sat, 10 Jun 2006 13:15:15 -0400
Message-ID: <1149959715.15368.47.camel@vaio1linux> (raw)
In-Reply-To: <664.1149956898@sss.pgh.pa.us>
References: <1149944622.15368.38.camel@vaio1linux>
<664.1149956898@sss.pgh.pa.us>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: listman@elkenserver.net, tgl@sss.pgh.pa.us, pgsql-general@postgresql.org
Subject: Re: TOAST not working
In-Reply-To: <1149959715.15368.47.camel@vaio1linux>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox