Re: Index usage - Mailing list pgsql-general

From Pedro Alves
Subject Re: Index usage
Date
Msg-id 20030826142402.GA13557@cosmos.inesc.pt
Whole thread Raw
In response to Index usage  (Pedro Alves <pmalves@think.pt>)
List pgsql-general
On Tue, Aug 26, 2003 at 04:21:52PM +0200, Dennis Björklund wrote:
> On Tue, 26 Aug 2003, Pedro Alves wrote:
>
> >     It's the same even with statistics=1000.
>
> And just to be sure, you ran vacuum analyze on the tables by hand after
> the alter table?


    Yes

>
> >     Is there any way to enable_seqscan=off just for this query?
>
> Just set it before you run the query.

    Ok


--
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index usage
Next
From: Dennis Björklund
Date:
Subject: Re: Index usage