Re: Index usage - Mailing list pgsql-general

From Dennis Björklund
Subject Re: Index usage
Date
Msg-id Pine.LNX.4.44.0308261621060.31606-100000@zigo.dhs.org
Whole thread Raw
In response to Index usage  (Pedro Alves <pmalves@think.pt>)
List pgsql-general
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?

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

Just set it before you run the query.


--
/Dennis


pgsql-general by date:

Previous
From: Pedro Alves
Date:
Subject: Re: Index usage
Next
From: Pedro Alves
Date:
Subject: Re: Index usage