Re: [GENERAL] Re: can't seem to use index - Mailing list pgsql-general

From admin
Subject Re: [GENERAL] Re: can't seem to use index
Date
Msg-id Pine.BSF.4.10.10001111110270.58707-100000@server.b0x.com
Whole thread Raw
In response to Re: [GENERAL] Re: can't seem to use index  (Patrick Welche <prlw1@newn.cam.ac.uk>)
List pgsql-general
Yes, I did try vacuum analyze, but my search query still uses a sequential
scan.

> > I then tried changing the btree index to a hash talbe and went through the
> > same procedure of vacumming and restarting a psql session. Yet again, the
> > index wasn't being used.
>
> But did you try vacuum analyze or just vacuum?
>


pgsql-general by date:

Previous
From: Jeff MacDonald
Date:
Subject: Re: [GENERAL] Intro/Win9X
Next
From: Robert Rothe
Date:
Subject: Question on timestamp in psql