From: Jan Wieck <janwieck@Yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Hannu Krosing <hannu@tm.ee>
Cc: Jan Wieck <janwieck@Yahoo.com>
Cc: D. Johnson <dspectra@home.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: Re: Postgres and Oracle differences and questions
Date: Thu, 8 Feb 2001 07:50:01 -0500 (EST)
Message-ID: <200102081250.HAA03586@jupiter.greatbridge.com> (raw)
In-Reply-To: <28278.981560178@sss.pgh.pa.us>
Tom Lane wrote:
>
> Speaking of which, though, it looks like an update or insert will
> forcibly uncompress (and later recompress) a compressed-in-line datum,
> which seems like a waste of cycles to me. Jan, shouldn't the test for
> VARATT_IS_EXTENDED at line 357 instead read VARATT_IS_EXTERNAL?
Not without some more logic added.
We don't have any admin commands yet that can modify the
toasters strategy on the attribute level, but the config
attributes in the tuple descriptor are already there. So you
can tell the toaster per attribute if it should try to
compress or not, if it should try to keep the attribute in
the main tuple harder and the like. You have to modify
pg_attribute yourself for now, where we might want to have
some ALTER TABLE, don't we?
IIRC the above should only be invoked if you do something
like INSERT ... SELECT, where the already toasted value is
coming from another tuple than the one you're actually
creating/updating.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
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-interfaces@postgresql.org
Cc: janwieck@Yahoo.com, tgl@sss.pgh.pa.us, hannu@tm.ee, dspectra@home.com
Subject: Re: Re: Postgres and Oracle differences and questions
In-Reply-To: <200102081250.HAA03586@jupiter.greatbridge.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