More indexes...more better?

From: Varun Kacholia <varunk(at)cse(dot)iitb(dot)ac(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: More indexes...more better?
Date: 2002-06-24 20:50:22
Message-ID: 20020625022303.A15855@voxel.cse.iitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi ,
I wanted to know whether it is better (speed-wise) to have more
indexes .Or one should try to have less number of them , so that
as much as possible all can be stored 'in-memory'? Or is it
that they are loaded 'in-memory' only after the analyzer
decides which of them to use?
I am having 12 indexes on 6 tables(they are huge with 0.5 million
rows in each).
thanks for any help
--
------
Varun
Why doesn't DOS ever say "EXCELLENT command or filename!"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2002-06-24 20:52:08 Re: PostgreSQL now part of the Lindows "Click-n-Run"
Previous Message Vince Vielhaber 2002-06-24 20:15:59 Re: website design