index recognition - Mailing list pgsql-admin

From Jodi Kanter
Subject index recognition
Date
Msg-id 008801c2df48$ad0bdb70$de138f80@virginia.edu
Whole thread Raw
List 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@virginia.edu


 

 

 

pgsql-admin by date:

Previous
From: Jodi Kanter
Date:
Subject: indexes
Next
From: Jean-Luc Lachance
Date:
Subject: Re: psql wrap