From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to use 'toast' |
Date: | 2007-10-22 20:59:40 |
Message-ID: | 60ve8yeugz.fsf@dba2.int.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sascha Bohnenkamp <asbohnenkamp(at)gmx(dot)de> writes:
> I tryed to use large-object and saw some 'toast' while reading the
> documentation :)
>
> How do i use it?
You generally merely need to add data to your tables; if columns are
large enough, then PostgreSQL will consider TOASTing them without you
needing to take any action yourself.
In 8.4, it is fairly likely that there will be some extra "knobs" to
allow tuning TOAST usage so that you could encourage its use at lower
levels for particular tables/columns.
At present, the parameterization is at the #define level (e.g. - deep
inside the binaries); if a tuple is >4096 bytes in size, then TOASTing
will be considered.
--
select 'cbbrowne' || '@' || 'linuxfinances.info';
http://cbbrowne.com/info/lisp.html
When I met th'POPE back in '58, I scrubbed him with a MILD SOAP or
DETERGENT for 15 minutes. He seemed to enjoy it ...
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-10-22 21:01:45 | Re: unicode searches failing that use % and LIKE operators |
Previous Message | Tomas Vondra | 2007-10-22 20:47:10 | Re: Bitmap Heap scan 8.1/8.2 |