Re: Multicolumn index - is there a limit?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fran Fabrizio <ffabrizio(at)exchange(dot)webmd(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Multicolumn index - is there a limit?
Date: 2001-05-02 04:28:29
Message-ID: 9768.988777709@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Fran Fabrizio <ffabrizio(at)exchange(dot)webmd(dot)net> writes:
> I then ran some tests. It's still taking .433 seconds on average. Is a 5
> column multicolumn index too much for postgres to handle?

No, but without some EXPLAIN output (maybe even EXPLAIN VERBOSE output)
it's quite impossible for anyone to guess what may be happening here.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2001-05-02 04:29:07 Re: making with ssl support
Previous Message Harry Yau 2001-05-02 02:10:36 Re: Re: function with multi-values