Postgres Pro
Downloads
Home   >   mailing lists

Re: does postgres has the same limitation as MySQL? - Mailing list pgsql-general

From Jonah H. Harris
Subject Re: does postgres has the same limitation as MySQL?
Date
Msg-id 36e682920901051053n155e57ffhe62c109ba5b0165c@mail.gmail.com
Whole thread Raw
In response to Re: does postgres has the same limitation as MySQL?  (Chris Browne <cbbrowne@acm.org>)
List pgsql-general
Tree view
On Mon, Jan 5, 2009 at 12:05 PM, Chris Browne <cbbrowne@acm.org> wrote:
tekion <tekion@gmail.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

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Vacuum problems
Next
From: Mohamed
Date:
Subject: Re: Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..