All Questions
Tagged with cube postgresql
2 questions
1
vote
0
answers
345
views
Why does a GIST index on a cube column in PostgreSQL actually make K-Nearest Neighbor (KNN) ORDER BY queries worse?
Adding a GIST index actually seems to make K-Nearest Neighbor (KNN) ORDER BY queries on cube columns worse in PostgreSQL. Why would that be, and what can be done about it?
Here's what I mean. In a ...
3
votes
1
answer
658
views
Have several 128 elements lists, need to obtain distance between them
Is storing them in a CUBE type field and then getting euclidean distance, (using <->) the only way?
I can not save them as a list of floats, since i get: "can't adapt type numpyndarray"
Can ...
- 41