Postgres Pro
Downloads
Home   >   mailing lists

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

From Patrick Welche
Subject Re: [GENERAL] Re: can't seem to use index
Date
Msg-id 20000111122712.C7663@quartz.newn.cam.ac.uk
Whole thread Raw
In response to Re: can't seem to use index  (admin <admin@wtbwts.com>)
Responses Re: [GENERAL] Re: can't seem to use index  (admin <admin@wtbwts.com>)
List pgsql-general
Tree view 
> 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: Ron Chmara
Date:
Subject: Re: [GENERAL] Intro/Win9X
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Dirty workaround to get the results and the errors in the same output file