index recognition

From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: index recognition
Date: 2003-02-28 16:44:35
Message-ID: 008801c2df48$ad0bdb70$de138f80@virginia.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Is there something I need to do to have postgres recognize the indexes I have just created. I see them when I do a \d tablename but when I do an explain on my queries it still states that it is doing a sequential scan.

Thanks
Jodi

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu


Browse pgsql-admin by date

  From Date Subject
Next Message Jean-Luc Lachance 2003-02-28 19:12:38 Re: psql wrap
Previous Message Tycho Fruru 2003-02-28 16:31:10 Re: Cross-database references