Hi Tom,
thanks for your suggestion:
> Markus Innerebner writes:
>> The query plan says, that a sequential scan is performed on the edge table.
>> I consider it strange that he is not accessing on the (btree) index one the
>> edge table.
>
> This suggests that you have a datatype mismatch:
>
Markus Innerebner writes:
> The query plan says, that a sequential scan is performed on the edge table. I
> consider it strange that he is not accessing on the (btree) index one the
> edge table.
This suggests that you have a datatype mismatch:
> " Hash Cond: ((e.target)::numeric = n.id)"
Yo
hi all
In my query I have two tables (edges 3,600,000 tuples and nodes 1,373,00
tuples), where I want to obtain all edges,whose target vertex is within a given
euclidean range starting from a query point q:
the query is formulated as following:
SELECT
E.ID,
E.SOURCE,E.SOURCE_MODE,E.TARGET,E
