Re: [HACKERS] How to implement a SP-GiST index as a extension module?

2017-11-12 Thread Connor Wolf
mplement a SP-GiST index too. Thanks! On Sun, Nov 5, 2017 at 8:10 PM, Connor Wolf wrote: > Never mind, it turns out the issue boiled down to me declaring the > wrong prefixType in my config function. > > TL;DR - PEBKAC > > On Sun, Nov 5, 2017 at 1:09 AM, Connor Wolf com> wrot

Re: [HACKERS] How to implement a SP-GiST index as a extension module?

2017-11-05 Thread Connor Wolf
Never mind, it turns out the issue boiled down to me declaring the wrong prefixType in my config function. TL;DR - PEBKAC On Sun, Nov 5, 2017 at 1:09 AM, Connor Wolf wrote: > Ok, I've got everything compiling and it installs properly, but I'm > running into problems that I th

Re: [HACKERS] How to implement a SP-GiST index as a extension module?

2017-11-05 Thread Connor Wolf
at8GetDatum(coord); for example. I think this is the SP-GiST core failing to handle certain types being pass-by-value? I'm not totally certain. As I understand it, the "maybe-pass-by-reference" parameter is a global flag (USE_FLOAT8_BYVAL), but I'd like to keep that enabled. What&#

Re: [HACKERS] How to implement a SP-GiST index as a extension module?

2017-11-03 Thread Connor Wolf
umb questions. Postgresql is huge and I have no idea what I'm really doing. On Fri, Nov 3, 2017 at 12:20 AM, Robert Haas wrote: > On Thu, Nov 2, 2017 at 9:53 AM, Connor Wolf > wrote: > > As such: > > Will compound queries as I describe above basically require a custom > t

Re: [HACKERS] How to implement a SP-GiST index as a extension module?

2017-11-01 Thread Connor Wolf
<=> target_value < 4;", with "<=>" being the operator for the relevant distance calculation (hamming, for the BK tree, numeric for the VP-tree). The existing VP-tree code appears to not support multiple operators whatsoever, probably because it was very prelim

Re: [HACKERS] How to implement a SP-GiST index as a extension module?

2017-10-30 Thread Connor Wolf
ostgrespro.ru> wrote: > Hi! > > On Sun, Oct 29, 2017 at 12:07 PM, Connor Wolf < > w...@imaginaryindustries.com> wrote: > >> I'm looking at implementing a custom indexing scheme, and I've been >> having trouble understanding the proper approach. >>

[HACKERS] How to implement a SP-GiST index as a extension module?

2017-10-30 Thread Connor Wolf
Hi there! I'm looking at implementing a custom indexing scheme, and I've been having trouble understanding the proper approach. Basically, I need a BK tree, which is a tree-structure useful for indexing arbitrary discrete metric-spaces (in my case, I'm interested in indexing across the hammi

Re: [HACKERS] [GENERAL] Understanding and implementing a GiST Index

2014-10-10 Thread Connor Wolf
rs mailing list for that. Also, do you want GiST or SP-GiST ? We already use hamming distance in rd-tree, which implemented in GiST, see our presentation http://www.sai.msu.su/~megera/postgres/talks/pgcon-2012.pdf <http://www.sai.msu.su/%7Emegera/postgres/talks/pgcon