Re: Indexes not used

From: "D(dot) Duccini" <duccini(at)backpack(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Indexes not used
Date: 2001-03-15 20:48:11
Message-ID: Pine.GSO.4.03.10103151447010.2896-100000@ra.bpsi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


> > 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(at)backpack(dot)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!"
-----------------------------------------------------------------------------

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-03-15 21:04:26 Re: Indexes not used
Previous Message Tom Lane 2001-03-15 20:46:11 Re: Indexes not used