On Sat, Jun 10, 2006 at 10:43:02PM -0400, Angus Berry wrote:
> Ahhh... thank you. This clarifies TOAST for me. I see how TOAST applies
> to individual columns that exceed the 8k page size.
>
> Postgres specs state it's possible to have 2GB rows and up to 1,600
> columns. Can you tell me what data
Ahhh... thank you. This clarifies TOAST for me. I see how TOAST applies
to individual columns that exceed the 8k page size.
Postgres specs state it's possible to have 2GB rows and up to 1,600
columns. Can you tell me what data type would get to fill this spec. I
wouldn't normally push to this limi
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Actually, it's BLCKSZ/4. From
> http://www.postgresql.org/docs/8.1/interactive/storage-toast.html:
> "The TOAST code is triggered only when a row value to be stored in a
> table is wider than BLCKSZ/4 bytes (normally 2Kb)."
> BTW, 'row value' seems a b
On Sat, Jun 10, 2006 at 05:10:06PM -0400, Christopher Browne wrote:
> Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (list_man) would
> write:
> > Can someone tell me if I have to 'enable' TOAST on columns to have it
> > kick in. According to my research, numeric data types are toastab
After a long battle with technology, [EMAIL PROTECTED] (list_man), an
earthling, wrote:
> Hi,
>
> I wonder if anyone can help.
>
> I have a VERY wide table and rows. There are over 800 columns of type:
> numeric(11,2)
>
> I can create the table no problem, but when I go to fill out a full row
> wi
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (list_man) would
write:
> Can someone tell me if I have to 'enable' TOAST on columns to have it
> kick in. According to my research, numeric data types are toastable.
TOAST is only used on individual columns that exceed 8K in size.
The o
Hi,
I wonder if anyone can help.
I have a VERY wide table and rows. There are over 800 columns of type:
numeric(11,2)
I can create the table no problem, but when I go to fill out a full row
with data, I get the message about reaching the 8k limit.
Can someone tell me if I have to 'enable' TOAST
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
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
---
Hi,
I wonder if anyone can help.
I have a VERY wide table and rows. There are over 800 columns of type:
numeric(11,2)
I can create the table no problem, but when I go to fill out a full row
with data, I get the message about reaching the 8k limit.
Can someone tell me if I have to 'enable' TOAS
10 matches
Mail list logo
