Re: Force PostgreSQL to query a custom index structure - Mailing list pgsql-general

From Tom Lane
Subject Re: Force PostgreSQL to query a custom index structure
Date
Msg-id 20295.1270045252@sss.pgh.pa.us
Whole thread Raw
In response to Force PostgreSQL to query a custom index structure  (Carsten Kropf <ckropf2@fh-hof.de>)
List pgsql-general
Carsten Kropf <ckropf2@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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Migration - not null default '0' -> not null default 0 - confused
Next
From: Raymond O'Donnell
Date:
Subject: Re: Migration - not null default '0' -> not null default 0 - confused