Index Management - Mailing list pgsql-sql

From pocm@rnl.ist.utl.pt (Paulo J. Matos)
Subject Index Management
Date
Msg-id 87d6zr1fdm.fsf@localhost.localdomain
Whole thread Raw
List pgsql-sql
Hi all,

I've been creating indeces for my tables but I'm a bit lost
now. I'd like to know how indeces are managed? Are them
autommaticly chosen for a particular query? We choose the good
ones (maybe through a sql command)?
If I create 10 indeces and then I make some queries, how will
postgres manage the indeces and how to work through the queries?

Best regards,

-- 
Paulo J. Matos : pocm(_at_)rnl.ist.utl.pt
Instituto Superior Tecnico - Lisbon    
Software & Computer Engineering - A.I.- > http://www.rnl.ist.utl.pt/~pocm ---    Yes, God had a deadline...    So, He
wroteit all in Lisp!
 



pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Difference between Access97 and PostgreSQL
Next
From: "Yan Bai"
Date:
Subject: How to merge several attributes and Delete an attribute