>ANN is beyond concepts of SQL standard: database with index must return same
>results as without index.
>I can add ANN to github.com/x4m/ags which is a fork of GiST.How to recompile
>that extension and not to get a name conflict with a standard one?
I've renamed everything for cube extension.
A uniform set of points with a dimension 128 and type cube. That has a size of
50 ** 3. Can be queried for a nearest neighbor at a speed of 10 queries per
second with limit varying from 1 to 25.
It works better than when no index used at all. So gist gives here a speed up.
The documentation of po
I've added debug prints to cube extension. g_custom_cube_a_f8 and
g_custom_cube_picksplit are the only called methods.
After that it prints:
ERROR: failed to add item to index page in "lc_idx"
Cube extension modifications:
#define MAX_DIM (512)
Python test source code has been attached
I've added debug prints to cube extension.g_custom_cube_a_f8
g_custom_cube_picksplit
are the only called methods
after that it prints
import psycopg2
import logging
import numpy
import unittest
import python.utils.logging
import python.custom_db.backends
import python.custom_db.backends.postgres
Can you point out a failling unit test in the codebase?
P.S sorry for a late reply, has got this message in the spam folder )
Le lundi 10 juin 2019 à 14:57:32 UTC+3, Daniel Gustafsson
a écrit :
> On 9 Jun 2019, at 20:05, Siarhei Siniak wrote:
>
> I've been using
I've been using cube extension recompiled with #define MAX_DIM 256.
But with a version 11.3 I'm getting the following error:failed to add item to
index page in
There's a regression unit test in contrib/cube/expected/cube.out:
CREATE TABLE test_cube (c cube);
\copy test_cube from 'data/test_cube.d
-- Forwarded message -
From: Siarhei Siniak
Date: Tue, 5 Mar 2019 at 23:31
Subject: Re: [Issue] Can't recompile cube extension as PGXS, utils/float.h
is not installed
To: Tom Lane
>AFAICT, that file only exists in HEAD, not in any released branch, and
>it is insta
1. Currently, cube extension has CUBE_MAX_DIM set as 100.
A recent github issue. [1]
2. To compile a custom version of the extension off the tree requires:
```
make -C contrib/custom_cube USE_PGXS=1
```
3. But utils/float.h required by cube.c and cubeparse.y is not installed.
It's not present in
