Re: GIST and TOAST

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: andrew(at)supernews(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: GIST and TOAST
Date: 2007-03-05 16:29:31
Message-ID: 45EC456B.4000604@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> A closer reading, however, shows that at least for cases like intarray,
> btree_gist, etc., the detoasting of an index value is being done in the
> gist decompress function, so the value seen via GISTENTRY in the other
> functions should already have been detoasted once.

Right, any stored value form index should be decompressed by GiST decompress
support method.

Another places:
- compress might get original value in case of inserting new one, in all other
cases it gets value produced by decompress method.
- query in consistent method

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2007-03-05 16:32:53 Re: Latest plans for Utilities with HOT
Previous Message Pavel Stehule 2007-03-05 16:29:04 proposal: custom variables management