Re: TOAST not working - Mailing list pgsql-general

From Christopher Browne
Subject Re: TOAST not working
Date
Msg-id 87bqt03efl.fsf@wolfe.cbbrowne.com
Whole thread Raw
In response to TOAST not working  (list_man <listman@elkenserver.net>)
Responses Re: TOAST not working  ("Jim C. Nasby" <jnasby@pervasive.com>)
Re: TOAST not working  (Angus Berry <angus.berry@elkenserve.com>)
List pgsql-general
Centuries ago, Nostradamus foresaw when listman@elkenserver.net (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 only way you'll be TOASTing numeric columns is if they are
individually defined to occupy > 8192 bytes.

Those are *BIG* numeric values; perhaps you're misunderstanding the
intent of TOAST...
--
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/slony.html
What do little birdies see when they get knocked unconscious?

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: TOAST not working
Next
From: "Yavuz Kavus"
Date:
Subject: are there static variables in pgsql?