Re: Multicolum index and primary key - Mailing list pgsql-sql

From Michele Bendazzoli
Subject Re: Multicolum index and primary key
Date
Msg-id 1069154662.8336.64.camel@mickymouse.sintel
Whole thread Raw
In response to Multicolum index and primary key  (Michele Bendazzoli <mickymouse@mickymouse.it>)
List pgsql-sql
On Mon, 2003-11-17 at 18:13, Tomasz Myrta wrote:
> Dnia 2003-11-17 19:00, Użytkownik Michele Bendazzoli napisał:
> > a is always present in the queries ... and other that (a, ab, abc) i
> > have only to query (ac): so I think I have to index separately only
> > (ac).
> 
> For such cases consider changing primary key from (a,b,c) into (a,c,b)

b,c are exactly simmetric, so if I change the primary key to (a,c,b) I
have to index separately (a,b) ... rigth? 

ciao, Michele



pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: multiple function declarations
Next
From: Bruno Wolff III
Date:
Subject: Re: Quota query with decent performance?