Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexes not used - Mailing list pgsql-novice

From D. Duccini
Subject Re: Indexes not used
Date
Msg-id Pine.GSO.4.03.10103151447010.2896-100000@ra.bpsi.net
Whole thread Raw
In response to Re: Indexes not used  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Indexes not used
List pgsql-novice
Tree view 
> > what is the analyze?  i've run vacuum several times
>
> VACUUM ANALYZE

i've done this as well, but it gives me no output other than "VACUUM"

or does it work silently in the background?

i've even dropped the index and recreated, but it didn't have any impact
on its use

-----------------------------------------------------------------------------
david@backpack.com            BackPack Software, Inc.        www.backpack.com
+1 651.645.7550 voice       "Life is an Adventure.
+1 651.645.9798 fax            Don't forget your BackPack!"
-----------------------------------------------------------------------------

pgsql-novice by date:

Previous
From: "D. Duccini"
Date:
Subject: Re: Indexes not used
Next
From: Tom Lane
Date:
Subject: Re: Indexes not used