multiple key indices vs single key - Mailing list pgsql-general

From admin
Subject multiple key indices vs single key
Date
Msg-id Pine.BSF.4.10.9912161132060.3479-100000@server.b0x.com
Whole thread Raw
List pgsql-general
When using a btree index, the manual says I can specify up to 7 keys in a
single multi-column index. Is there any difference between calling a
single index with 7 keys and calling 7 indices with 1 key each, btree in
both cases? In which instances should a btree index use only a single key?
Where could I have found this information in the online manual (read
chapter 7. Indices and Keys of the User's Guide).

Thanks again,
Marc


pgsql-general by date:

Previous
From: Jose Soares
Date:
Subject: \copy problem
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Czech2ASCII with --mb=Latin2