--On fredag, april 02, 2004 09.56.04 -0600 Bruno Wolff III <[EMAIL PROTECTED]> wrote:

On Fri, Apr 02, 2004 at 01:00:45 +0200,
  Palle Girgensohn <[EMAIL PROTECTED]> wrote:

Is it always bad to create index xx on yy (field1, field2, field3);


I guess the problem is that the index might often grow bigger than the
table, or at least big enough not to speed up the queries?

One place where you need them in postgres is enforcing unique multicolumn keys. These will get created implicitly from the unique (or primary key) constraint. It isn't all that unusual to have a table that describes a many to many (to many ...) relationship where the primary key is all of the columns.

True, of course!


/Palle


---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Reply via email to