Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Y0wEj-0002WQ-Tk for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Dec 2014 17:48:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Y0wEi-0006DV-U4 for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Dec 2014 17:48:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Y0wEh-0006DO-EY for pgsql-hackers@postgresql.org; Tue, 16 Dec 2014 17:48:39 +0000 Received: from hook.sigaev.ru ([93.180.27.50]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Y0wEU-0003vP-N2 for pgsql-hackers@postgresql.org; Tue, 16 Dec 2014 17:48:38 +0000 Received: from xor.sai.msu.ru (xor.sai.msu.ru [93.180.27.97]) (using TLSv1.2 with cipher DHE-RSA-AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: teodor) by hook.sigaev.ru (Postfix) with ESMTPSA id 835AC3982A; Tue, 16 Dec 2014 20:48:25 +0300 (MSK) Message-ID: <54907069.1030506@sigaev.ru> Date: Tue, 16 Dec 2014 20:48:25 +0300 From: Teodor Sigaev User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:34.0) Gecko/20100101 Firefox/34.0 SeaMonkey/2.31 MIME-Version: 1.0 To: Heikki Linnakangas , Pgsql Hackers Subject: Re: compress method for spgist - 2 Content-Type: multipart/mixed; boundary="------------030704060109030005040307" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org This is a multi-part message in MIME format. --------------030704060109030005040307 Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit > 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/ --------------030704060109030005040307 Content-Type: application/x-gzip; name="spgist_compress_method-3.patch.gz" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="spgist_compress_method-3.patch.gz" H4sIAERwkFQAA91ZbXMaORL+DL9C66vKQoABY8DO2nHFhZ0ctbZx2c7eh6sr apgRoPMwmprROPFu5b/f03oZ3h072U9HyiDNtFrS091Pt5RQTCas0ZgKxfxm KINmluJvOo+aWTIVmfKozcY7X5VFHPKvrNs7ah/yrueFfL97FByw/Var1+mU G43GM3rLtVrtOd0fPrBGu7Vfb7dYTf/usw8fyqzM2Enip/4pGux+xlPOfPxN xCNnecbTRsgnIuYhm3M1k2HG1MzH9mJm1ioTnvpKpiyI/CxjE5mWG9DoB6mM n+andzeNT+Lu/qTpHrB5nimWpPJRhNxj7CyKzFwTGUXyC7RzFsj4kcdKyJh0 yQnzg4AnSsRTpr5IdqKeEn4qYsXT2I9OmqdY8DSfY0RW1+MnIsUcGPdlJoIZ ExnzSVEi9RimJPNZn2UqzQNFkylfxKRcxEmu2KMf5VzvRCvL8iSRqbLbr5Mi qI24eckxPCzm11PtmOeLhlbmajEH6dJwjDlLIj/gIQD5KPOU1k7qHeT/JaGU qzyN7e4fpQix8zrLRBxwUuQDSIwRKQSzPFJYSZJwP8WutC47s1nNMRvnqlx7 saFg75DJGFoSMosfeQvDzfGOPOCJ9OkVZ9uN+TpLkrYdxvwBSzpta9b8MVOS si3mfL0ttQW22PNHjInoPZnkcUBIn0bcn4ywnwzRj81oZMNQGNtFT3Z+2qGZ fiwlhsQkZyb0LBsUy9Z7iyWQk6GYPMEhnmAaHuGV2aBILepmURm2P4hpI6Qp 8DNug3Nl6YQyLKaEH4k/wTHA+U+eSmA55jAbvAcKtLfMtJNvISSPQNz2nA2t r9oHS/AEcp5gn5nGRXtkRlrgxvmc1gAbanaDMnJ8h5Y1s3FEP1C5xvKLgLEW I7BvotSm5dQFvTYMoLuJFbT7Gy2jkCoi6xn5take/VT444hHMPypofxOp94D 43e69UMQPiN7Q5MzADJEX8YTMR2SD/1FxmJsKELmPgBqIr7eY9Sx7jffsnNf +VoPmV7EMdam8gRxZGQB0dvmpqLIH/NooedZRbEE5+gBWldtQxf8e0nVhi56 XyyCnNsNDPz4VluTxI/1wGFiUhdewdIUNAYZmYqpIPcJSfM2ZZGMp39onxj+ fsw2lAXIjfAONXOO82aKWN1niT/lWt+3FfSPjbl6Hdip1u716vvd79rLfE7M Ox2Op8uLIv/OZjKPQnLQjCsGQQAUk9vOuOaSrUp8pQheGi90gDu/ArLxFDui sNDRbNO/02J2LwiARMtjbManxKgUxrQ4h8aYaAikpuDSWT6B40CCooQ+lYxz dvIV/sQQ/w88Dt/vmWKmEYm5UNneadUzfvFC4TWUrANhh05Lnpl4nvmZSQj+ nJu1MjzZBQ+ol4mJ0yHUrxkDP06QHJBDFGEs12hoOw85DQtz2dQLQrl6biCB jWZCZA/AnR5dvqR+nKEx93X6naRyvnMfYD03dBdQHhG6mmnjZiZHSewwZW5Z dvFOj2HWneqsH3jsWir+GwILbrVIWcU+rO7M8OyUrynMEGkP/EkjAdGZH085 5XWEncwLLduRW8XHsz5c8KntEZUKxef2yUkTsRCZRaZPhmN771rEsYetVr3d 2R60l9h4v9hdEbzr2opnSyxOhrE5xGaHwqW25AX4A2URt4satVf1aUxOVuc1 OJ2g1pmfLsA61wnRQVYxXRFXAd5JU8u6gQuQHOLFgvWnT1VgqkxkaUIlaejS lZWxAVhAKE0a5LzJ7CkTSP/AUKbEmCIuPHRx/CAuhV8ql8adc8QI3tOCKwdU 2Xg7XL9QamO9SPjbdcF0G8q2sInRhiJkqUJ0wU1lFAJcSR/4hwWNFSbbcLza NlepbXpKrcyWT3O6RifAbXG/Vv3qCgKLAfbEe1RqwYsAs08LTYk8H3moFc35 nMoQqrD5VyQxfQYUqOjIjTQ+/TwlyrvSgn0jRzHmqiM4EFflcPmATKfUsR8Q XzfJfFlmz6v0E6LyhnMrL8CZ9oWS9vi87+8fBkHH8w5wau4dhKvH55fqMqfp l0oTC+wfdQ/06Vo3Do6ICJakKrc8MkSsl1lnd8knKLpTyIDsbUY/9TIr4QMD AspjdD7Op+kgnkiY4C3yQSCo/Z5df768xOtyo9R8iy/2ll1K+cDyhBUD7Klj hSCCmZQg7oKuJY4adWL+zH/kRk/wFEQ8c8eMSMoExsNRztOvUbOUxIRVfhFZ nEdRFQ9LS8vS+xqBot2zit3pPjZ782lwdz/q/3M4vLsY3dwO+9Xjcq30F/60 SlR3gwx1iwgrq2rCLUqGVze3F3d3Rk21Sjq0IoKDfrARofcP/6Zz3GYSxqb3 HK/t2YML0ZIbHkoQlMf+xWn7gj9y4/J2tDsQhNzGcDGMGNKzveaKhe70we4L 2E/GvyoyjMWLyG9kyl5h8+vZVZ0kZz7NK3EOeKCTa2ptZLjEHVPItShsM00r dj3HOHqm8wHpN6Qd4kxF005zkAOC06qiTTnTNpZNy968YdolG44pPfyi+GPv 38PTteXNcek9uzGH5E9c6bkqN59G5xf3wzNY6vzs/vNVRQtWtb1f7S8rpjYa 3LwfrR/3QVz7fRlFFaenruXMh5lpGqdpOEIrgJyOwn+3/rMqZlapp/hGXzh7 cHKjyrM4bHG9v8XSVtffY2urzFjbOecylK8y4TcqKtyG/x7uMYp2k0/NLpka P0c43+icXKKEfW73rrdGbPry5JQrEWXfz0xWrEhL7XaHTzzvcMK7re67V6Ql p+gFOcmJUkI6PKgfoSpFUmrbXAQD9/1gxtdyUdXkHYqCdU94g3Kv/szrgNQ1 UFZTbUQOQpwH32CfuD7/MDKLO4HA02NOlypj1OaMYyioNOKP8FLNvvr4rqmo NEHdQOF2zrOgmMWGYJ2hQbLGH39isqzwqrUctLItz9V3VaLF7a/YL++LVS1I QTPqz6Y2UBEOyijIKhe3t8PbgrUqPE0DGXJ63B+eX4wG13+cXQ7ORzdnt2dX F/cXtyP0P19UixEMI+bZtFKkvsWZQTOKC1Y/otPTdGYTI5XE+kbFQEZVoznj 7lU1JWj1zxtsB56rbLvA7RXWJzZiu0fcFNdX64tYXGyR1+7WcOnurTZ24V5U t7IHskCUh3w1RL2ZDeAdby1XHPj+u9449LzxeNILj7Zwxa7xC4rYJUHMcNCi SyZ8H+n/A/qHMbxzwptB//e7m8vBvfZCmONgQ2RwfQ336g+v79C7uLaSnQ25 y4uzjxtipW65sSp3fYN4MD7aLdfWdKzEBCR66xJLo3tE78hMqJfZmbvKtzfS +lgJGEbGftb3NR7mjvSlV6QlRLSuZIqbUU1CL7sWtYMXt6HPj12/CXXD3QXo 5mgdqRXX24ahvYOvmvXQjWaptHoxWnrVvahVsXIduq5h4zL09Lmb0J3BFGDO SE6bsKI/3wimtbc2mHqH4+5hgGDqddqH3W57dzCtj98MpnUJfe5rv6NoMj94 cH5x17+t7OkTt1mBCUHrcHtEF6iqziqmoGPDwTnKkPZhp80qjAHbUqnFemxi /yGz2V/6bpGAHYjWmOOL7sBYg7rILGOh5n5CHRA8vUALlYJrzv30IZGZfa9S 2x7nIgqLBp8n6sn0oocQSRMnVPQe/SDP5wH9TxHKPT1hIFGCZkrMfSNizlkZ 05WAA2JwvRMHF8iQGZ1djQgKAqLc2ASo02q1CCBDZICoW0BkwFG23dIiZiha C4jQAUAmrkzbgoWOBQstBxaaDizz3oBFGjVYrmHA0r0CLPRWwcID6LT3StRZ xg39ZdxqL9h77/90785n3I3V9/zG0pt1HYJpW2wddI80fOMUwdVl+5214FJF cJGEHUrN5fCi/gI26lncqOmAo7ZDzooY6LQ2jV3RMuCZboEeddfjjJ6tgEYP llH7H2yM6xZ4IgAA --------------030704060109030005040307 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers --------------030704060109030005040307--