Question about indexes

From: "regme please" <regmeplease(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about indexes
Date: 2008-09-09 14:52:34
Message-ID: 446c7e870809090752i6a256b96v8bc1f98833fc5de1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.
I usually create indexes accordingly to the queries used in my software.
This means the more often than not I have composited indexes over more than
one column.
What'd be in PGSQL (v8.3+) the pros and cons of having instead only
one-column indexes?
Thanks in advance.

RMP.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2008-09-09 15:00:34 Re: Various intermittent bugs/instability - how to debug?
Previous Message Robert Treat 2008-09-09 14:51:58 Re: Install Postgres on a SAN volume?