Postgres Pro
Downloads
Home   >   mailing lists

Re: Multicolumn index - is there a limit? - Mailing list pgsql-general

From Tom Lane
Subject Re: Multicolumn index - is there a limit?
Date
Msg-id 9768.988777709@sss.pgh.pa.us
Whole thread Raw
In response to Multicolumn index - is there a limit?  (Fran Fabrizio <ffabrizio@exchange.webmd.net>)
List pgsql-general
Tree view 
Fran Fabrizio <ffabrizio@exchange.webmd.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

pgsql-general by date:

Previous
From: "Eric G. Miller"
Date:
Subject: Improve a query...
Next
From: Justin Clift
Date:
Subject: Re: making with ssl support