From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-general@postgresql.org
Subject: Re: TOAST not working
Date: Sat, 10 Jun 2006 17:10:06 -0400
Message-ID: <87bqt03efl.fsf@wolfe.cbbrowne.com> (raw)
References: <1149944622.15368.38.camel@vaio1linux>
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?
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: cbbrowne@acm.org, pgsql-general@postgresql.org
Subject: Re: TOAST not working
In-Reply-To: <87bqt03efl.fsf@wolfe.cbbrowne.com>
* 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