From: Michele Bendazzoli <mickymouse@mickymouse.it>
To: Tomasz Myrta <jasiek@klaster.net>
Subject: Re: Multicolum index and primary key
Date: Tue, 18 Nov 2003 12:24:23 +0100
Message-ID: <1069154662.8336.64.camel@mickymouse.sintel> (raw)
In-Reply-To: <3FB9019C.7040402@klaster.net>
References: <1069088432.8338.16.camel@mickymouse.sintel>
<1069086197.77562.12.camel@jester>
<1069092026.8338.52.camel@mickymouse.sintel>
<3FB9019C.7040402@klaster.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mickymouse@mickymouse.it, jasiek@klaster.net
Subject: Re: Multicolum index and primary key
In-Reply-To: <1069154662.8336.64.camel@mickymouse.sintel>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox