Re: does postgres has the same limitation as MySQL?

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Chris Browne" <cbbrowne(at)acm(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: does postgres has the same limitation as MySQL?
Date: 2009-01-05 18:53:05
Message-ID: 36e682920901051053n155e57ffhe62c109ba5b0165c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 5, 2009 at 12:05 PM, Chris Browne <cbbrowne(at)acm(dot)org> wrote:

> tekion <tekion(at)gmail(dot)com> writes:
> > I know that MySQL can only use one index at at time for query. Does
> > Postgres has this same limitation? For example, the following query:

This is false for many cases since MySQL 5.0.

http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html

--
Jonah H. Harris, Senior DBA
myYearbook.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mohamed 2009-01-05 19:19:47 Re: Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..
Previous Message Scott Marlowe 2009-01-05 18:40:27 Re: Vacuum problems