Re: Index usage

    It's the same even with statistics=1000.

    Is there any way to enable_seqscan=off just for this query?


On Tue, Aug 26, 2003 at 10:07:02AM -0400, Tom Lane wrote:
> Pedro Alves <pmalves@think.pt> writes:
> > The vacuum analyze is run on daily basis, so that cannot be the point.
>
> The next thing I'd try to improve the planner's guess is to increase the
> statistics target for the ra_datacolh column (see ALTER TABLE SET
> STATISTICS).  It looks like the default of 10 is too small for that
> column --- try 100 and see if the rowcount estimates get any closer.
>
>             regards, tom lane

--
Pedro Miguel G. Alves            pmalves@think.pt
THINK - Tecnologias de Informação    www.think.pt
Tel:   +351 21 413 46 00  Av. José Gomes Ferreira
Fax:   +351 21 413 46 09     nº 13 1495-139 ALGÉS