single index on more than two coulumns a bad thing?

From: Palle Girgensohn <girgen(at)pingpong(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: single index on more than two coulumns a bad thing?
Date: 2004-04-01 23:00:45
Message-ID: 24070000.1080860445@palle.girgensohn.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I remember reading a post ages ago, maybe from Vadim, about the fact that
people creating indices on more than two columns will be the first to be
put againts the wall when the revolution comes... sort of...

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?

/Palle

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-04-02 00:35:45 Re: single index on more than two coulumns a bad thing?
Previous Message Magnus Naeslund(t) 2004-04-01 20:19:14 Re: PostgreSQL and Linux 2.6 kernel.