From: Teodor Sigaev <teodor@sigaev.ru>
To: Heikki Linnakangas <hlinnakangas@vmware.com>
To: Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: compress method for spgist - 2
Date: Tue, 16 Dec 2014 20:48:25 +0300
Message-ID: <54907069.1030506@sigaev.ru> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
> For some datatypes, the compress method might be useful even if the leaf
> type is the same as the column type. For example, you could allow
> indexing text datums larger than the page size, with a compress function
> that just truncates the input.
Agree, and patch allows to use compress method in this case, see begining of
spgdoinsert()
> Could you find some use for this in one of the built-in or contrib
> types? Just to have something that exercises it as part of the
> regression suite. How about creating an opclass for the built-in polygon
> type that stores the bounding box, like the PostGIS guys are doing?
Will try, but I don't have nice idea. Polygon opclass will have awful
performance until PostGIS guys show the tree structure.
> The documentation needs to be updated.
Added.
--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackersAttachments:
spgist_compress_method-3.patch.gz (application/x-gzip, 2.9K) download
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-hackers@postgresql.org
Cc: teodor@sigaev.ru, hlinnakangas@vmware.com
Subject: Re: compress method for spgist - 2
In-Reply-To: <54907069.1030506@sigaev.ru>
* 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