Carsten Kropf <ckro...@fh-hof.de> writes:
> I have a question according to a customly built index. I want to force the
> query planner to search in my index structure, whenever I have a query that
> uses my specified operator. Until now, I always have to insert a quite amount
> of tuples (~ 20000-30000) for being able to get an index scan instead of a
> sequential scan.
This is a good thing. If you screw up the cost estimates to the point
where it won't do that, you will be very unhappy with the results.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
