Re: Force PostgreSQL to query a custom index structure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carsten Kropf <ckropf2(at)fh-hof(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Force PostgreSQL to query a custom index structure
Date: 2010-03-31 14:20:52
Message-ID: 20295.1270045252@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Carsten Kropf <ckropf2(at)fh-hof(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2010-03-31 14:27:03 Re: Migration - not null default '0' -> not null default 0 - confused
Previous Message Tom Lane 2010-03-31 14:09:56 Re: Migration - not null default '0' -> not null default 0 - confused