Re: [GENERAL] Re: can't seem to use index

[admin]

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


************