Re: Index usage

From: Dennis Björklund <db(at)zigo(dot)dhs(dot)org>
To: Pedro Alves <pmalves(at)think(dot)pt>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostGreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Index usage
Date: 2003-08-26 14:21:52
Message-ID: Pine.LNX.4.44.0308261621060.31606-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pedro Alves 2003-08-26 14:24:02 Re: Index usage
Previous Message Pedro Alves 2003-08-26 14:20:14 Re: Index usage