Re: Using more tha one index per table
| От | Rob Wultsch |
|---|---|
| Тема | Re: Using more tha one index per table |
| Дата | |
| Msg-id | AANLkTilBKkfLTLOsiRyjY0MK8oRYqWxmNCx1PZhOMofO@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Using more tha one index per table ("A. Kretschmer" <andreas.kretschmer@schollglas.com>) |
| Ответы |
Re: Using more tha one index per table
|
| Список | pgsql-performance |
On Wed, Jul 21, 2010 at 12:53 AM, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
In response to Elias Ghanem :> Hi,That's not true, but it's true for MySQL, afaik.
> I have a question concerning the uses of indexes in Postgresql.
> I red that in PG a query can not use more than one index per table: "a query or
> data manipulation command can use at most one index per table".
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
That is not true either, though MySQL is less good at using bitmap'ed indexes. 5.0 can use "merge indexes",
--
Rob Wultsch
wultsch@gmail.com
В списке pgsql-performance по дате отправления: