pg.ddx.io  pgsql-students@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alexander Korotkov <aekorotkov@gmail.com>
Cc: Heikki Linnakangas <hlinnakangas@vmware.com>
Cc: Stas Kelvich <stas.kelvich@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: pgsql-students@postgresql.org
Subject: Re: [HACKERS] Cube extension point support // GSoC'13
Date: Tue, 22 Oct 2013 00:00:24 +0200
Message-ID: <m28uxmthc7.fsf@2ndQuadrant.fr> (raw)
In-Reply-To: <3819.1382384476@sss.pgh.pa.us>
References: <23364502-F542-4553-A658-4D3A2B6FCFA9@gmail.com>
	<5236A9BC.3030000@vmware.com>
	<EF7A0879-4E83-4AAE-997D-222D6761E1C6@gmail.com>
	<CA+TgmoZdaou7E9wBApexPkYvOiEKBW2Xp8+G6rNFYxav8gVT4Q@mail.gmail.com>
	<5258038C.9070409@vmware.com>
	<CAPpHfdu-6COA6VA+50Q9cF=rEGn3DnzvhnUjbkpqXj4m_1zAVg@mail.gmail.com>
	<52657B1C.7050906@vmware.com>
	<CAPpHfduVqAv7M4HO4RqEESTaC1zZ+wkCc-GtdGD++02FiGEunQ@mail.gmail.com>
	<3819.1382384476@sss.pgh.pa.us>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-students>

Tom Lane <tgl@sss.pgh.pa.us> writes:
> I believe the reason GIST has compress/decompress functions is not for
> TOAST (they predate that, if memory serves), but to allow the on-disk
> representation of an index entry to be different from the data type's
> normal representation in other ways --- think lossy storage in particular.

My understanding of the use case for those functions is to do with
storing a different data type in the index upper nodes and in the index
leafs. It should be possible to do that in a non-lossy way, so that you
would implement compress/decompress and not declare the RECHECK bits.

Then again I'm talking from 8.3 era memories of when I tried to
understand GiST enough to code the prefix extension.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


-- 
Sent via pgsql-students mailing list (pgsql-students@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-students



view thread (12+ messages)  latest in thread

Message-ID: <m28uxmthc7.fsf@2ndQuadrant.fr>
Permalink:  ../m28uxmthc7.fsf@2ndQuadrant.fr/
Also on:    postgresql.org/message-id/m28uxmthc7.fsf@2ndQuadrant.fr

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-students@postgresql.org
  Cc: dimitri@2ndQuadrant.fr, tgl@sss.pgh.pa.us, aekorotkov@gmail.com, hlinnakangas@vmware.com, stas.kelvich@gmail.com, robertmhaas@gmail.com, pgsql-hackers@postgresql.org
  Subject: Re: [HACKERS] Cube extension point support // GSoC'13
  In-Reply-To: <m28uxmthc7.fsf@2ndQuadrant.fr>
  References: <23364502-F542-4553-A658-4D3A2B6FCFA9@gmail.com> <5236A9BC.3030000@vmware.com> <EF7A0879-4E83-4AAE-997D-222D6761E1C6@gmail.com> <CA+TgmoZdaou7E9wBApexPkYvOiEKBW2Xp8+G6rNFYxav8gVT4Q@mail.gmail.com> <5258038C.9070409@vmware.com> <CAPpHfdu-6COA6VA+50Q9cF=rEGn3DnzvhnUjbkpqXj4m_1zAVg@mail.gmail.com> <52657B1C.7050906@vmware.com> <CAPpHfduVqAv7M4HO4RqEESTaC1zZ+wkCc-GtdGD++02FiGEunQ@mail.gmail.com> <3819.1382384476@sss.pgh.pa.us> <m28uxmthc7.fsf@2ndQuadrant.fr>

* 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