Markus Innerebner <markus.innereb...@inf.unibz.it> 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)"
Your index is presumably on e.target, not e.target::numeric, so it's not
applicable. Try to make the join columns the same datatype.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
