| From: | Christopher Browne <cbbrowne(at)acm(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: TOAST not working |
| Date: | 2006-06-10 21:10:06 |
| Message-ID: | 87bqt03efl.fsf@wolfe.cbbrowne.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-general |
Centuries ago, Nostradamus foresaw when listman(at)elkenserver(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-06-11 02:12:15 | Re: [GENERAL] TOAST not working |
| Previous Message | list_man | 2006-06-10 17:15:15 | Re: TOAST not working |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2006-06-10 21:11:11 | Re: Questions about indexes |
| Previous Message | Pat Maddox | 2006-06-10 20:30:46 | Questions about indexes |