Re: [DOCS] [GENERAL] TOAST not working

2006-06-10 Thread Jim C. Nasby
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

Re: [DOCS] [GENERAL] TOAST not working

2006-06-10 Thread Tom Lane
"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

Re: [DOCS] [GENERAL] TOAST not working

2006-06-10 Thread Jim C. Nasby
Dropping -general On Sat, Jun 10, 2006 at 10:58:49PM -0400, Tom Lane wrote: > "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 i