Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-10-23 Thread Andrey Borodin
> 22 окт. 2017 г., в 21:21, Tom Lane написал(а): > > Andrey Borodin writes: >> I was looking for a way to correctly drop compress\decompress functions from >> opclasses. > > Making a new opclass seems like a pretty grotty answer; it won't > help existing installations. Unfortunately in cube'

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-10-22 Thread Tom Lane
Andrey Borodin writes: > I was looking for a way to correctly drop compress\decompress functions from > opclasses. Making a new opclass seems like a pretty grotty answer; it won't help existing installations. I think what you need is to undo opclasscmds.c's decision that the dependencies should

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-10-22 Thread Andrey Borodin
Hi, Tom! > 20 сент. 2017 г., в 8:38, Tom Lane написал(а): > > Andrey Borodin writes: >> [ 0001-Allow-uncompressed-GiST-4.patch ] > > Pushed, with a bit more work on the documentation and some minor > cosmetic changes. > > I did not like the fact that the new code paths added by the patch > wer

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-20 Thread Alexander Korotkov
On Wed, Sep 20, 2017 at 5:02 PM, Tom Lane wrote: > Alexander Korotkov writes: > > On Wed, Sep 20, 2017 at 4:25 PM, Tom Lane wrote: > >> Yes. We don't allow out-of-line values, but we do allow compressed and > >> short-header values. > > > BTW, this comment looks still invalid for me... > > >>

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-20 Thread Tom Lane
Alexander Korotkov writes: > On Wed, Sep 20, 2017 at 4:25 PM, Tom Lane wrote: >> Yes. We don't allow out-of-line values, but we do allow compressed and >> short-header values. > BTW, this comment looks still invalid for me... >> #define SIGLENINT 4 /* >122 => key will *toast*, so very slow!!!

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-20 Thread Alexander Korotkov
On Wed, Sep 20, 2017 at 4:25 PM, Tom Lane wrote: > Andrey Borodin writes: > > You mentioned that probably there cannot be TOASTed values in the index. > > I need to settle this question in more deterministic way. > > Can you point where to look at the code or who to ask: > > Can there be TOASTed

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-20 Thread Tom Lane
Andrey Borodin writes: > You mentioned that probably there cannot be TOASTed values in the index. > I need to settle this question in more deterministic way. > Can you point where to look at the code or who to ask: > Can there be TOASTed values in index tuples? Yes. We don't allow out-of-line v

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-20 Thread Alexander Korotkov
On Wed, Sep 20, 2017 at 12:43 PM, Andrey Borodin wrote: > Hello Tom! Thanks for committing the patch! > > > 20 сент. 2017 г., в 8:38, Tom Lane написал(а): > > > > Andrey Borodin writes: > >> [ 0001-Allow-uncompressed-GiST-4.patch ] > > > > ... There's still room > > to improve the contrib opcla

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-20 Thread Andrey Borodin
Hello Tom! Thanks for committing the patch! > 20 сент. 2017 г., в 8:38, Tom Lane написал(а): > > Andrey Borodin writes: >> [ 0001-Allow-uncompressed-GiST-4.patch ] > > ... There's still room > to improve the contrib opclasses I have one important question regarding compress\decompres function

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-19 Thread Tom Lane
Andrey Borodin writes: > [ 0001-Allow-uncompressed-GiST-4.patch ] Pushed, with a bit more work on the documentation and some minor cosmetic changes. I did not like the fact that the new code paths added by the patch were untested, so I went ahead and removed the no-longer-needed no-op functions

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-15 Thread Alexander Korotkov
On Fri, Sep 15, 2017 at 3:36 PM, Andrey Borodin wrote: > > 14 сент. 2017 г., в 18:42, Alexander Korotkov > написал(а): > > It would be good if someone would write patch for removing useless > compress/decompress methods from builtin and contrib GiST opclasses. > Especially when it gives benefit

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-15 Thread Andrey Borodin
Dmitry and Alexander, thank you for looking into the patch! > 14 сент. 2017 г., в 18:42, Alexander Korotkov > написал(а): > It would be good if someone would write patch for removing useless > compress/decompress methods from builtin and contrib GiST opclasses. > Especially when it gives bene

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-14 Thread Alexander Korotkov
On Thu, Sep 14, 2017 at 2:20 PM, Dmitriy Sarafannikov < dsarafanni...@yandex.ru> wrote: > The following review has been posted through the commitfest application: > make installcheck-world: tested, passed > Implements feature: tested, passed > Spec compliant: tested, passed > Docu

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-14 Thread Dmitriy Sarafannikov
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: tested, passed Documentation:tested, passed This is simple and intuitive patch. Code looks pretty clear a

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-11 Thread Andrey Borodin
> 11 сент. 2017 г., в 12:57, Dmitriy Sarafannikov > написал(а): > Hi Andrew! Thanks for the patch, but patch > 0001-allow-uncompressed-Gist-2.patch no longer applies on current master > branch. > Please could you rebase it? Sure, see attachment. Thanks for looking into the patch! Best regards

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-09-11 Thread Dmitriy Sarafannikov
The following review has been posted through the commitfest application: make installcheck-world: not tested Implements feature: not tested Spec compliant: not tested Documentation:not tested Hi Andrew! Thanks for the patch, but patch 0001-allow-uncompressed-Gist-2.pat

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-05-29 Thread Andrew Borodin
2017-05-29 0:00 GMT+05:00 Tom Lane : > But the opclass's consistent function might expect to be always given an > untoasted input, in which case you'd need the decompress function to fix > that up. In cube data is detoasted at least 4 times before going to g_cube_internal_consistent(), including o

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-05-28 Thread Tom Lane
Andrew Borodin writes: > I'm not expert in toasting, cube's compress does nothing while cube > decomress does detoasting. Is this for reason? The original input datum could be toasted --- at least to the extent of being compressed in-line or having short header; I do not think we allow out-of-lin

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-05-28 Thread Andrew Borodin
28 мая 2017 г. 11:15 PM пользователь "Tom Lane" написал: Andrew Borodin writes: > 2017-05-28 22:22 GMT+05:00 Tom Lane : >> 2. If compress/decompress are omitted, then we could support index-only >> scans all the time, that is a no-op fetch function would work. The >> patch should cover that int

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-05-28 Thread Tom Lane
Andrew Borodin writes: > 2017-05-28 22:22 GMT+05:00 Tom Lane : >> 2. If compress/decompress are omitted, then we could support index-only >> scans all the time, that is a no-op fetch function would work. The >> patch should cover that interaction too. > I do not think so. Decompress have to get

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-05-28 Thread Andrew Borodin
Thanks, Tom! 2017-05-28 22:22 GMT+05:00 Tom Lane : > Andrew Borodin writes: >> Maybe we should make compress\decompress functions optional? > > 1. You'll need to adjust the documentation (gist.sgml) not just the code. Sure, I'll check out where compression is mentioned and update docs. > 2. If c

Re: [HACKERS] Allow GiST opcalsses without compress\decompres functions

2017-05-28 Thread Tom Lane
Andrew Borodin writes: > Maybe we should make compress\decompress functions optional? 1. You'll need to adjust the documentation (gist.sgml) not just the code. 2. If compress/decompress are omitted, then we could support index-only scans all the time, that is a no-op fetch function would work.