| From: | Pedro Alves <pmalves(at)think(dot)pt> |
|---|---|
| To: | Dennis Björklund <db(at)zigo(dot)dhs(dot)org> |
| 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:24:02 |
| Message-ID: | 20030826142402.GA13557@cosmos.inesc.pt |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)think(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-08-26 14:25:11 | Re: Index usage |
| Previous Message | Dennis Björklund | 2003-08-26 14:21:52 | Re: Index usage |