Georgos,
> select * from tmp where route >>= some_cidr
Can you post an EXPLAIN ANALYZE for this? And when's the last time you ran
ANALYZE on the table?
> The index on route is not used and I get a sequential scan. The index is
> used only for the <<= operator.
Most likely Postgres thinks that the >>= query is returning 60% of your table,
which makes indexes useless.
--
Josh Berkus
Aglio Database Solutions
San Francisco