Re: Index/Foreign Key Question

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Index/Foreign Key Question
Дата
Msg-id 1065987564.15342.2.camel@fuji.krosing.net
обсуждение исходный текст
Ответ на Re: Index/Foreign Key Question  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-performance
Andrew Sullivan kirjutas P, 12.10.2003 kell 22:28:
> On Fri, Oct 10, 2003 at 09:01:12PM -0500, Ron Johnson wrote:
> >
> > > Does PostgreSQL only pick one index per table on the select statements?
> >
> > That's it's preference.
>
> As far as I know, that's all it can do.  Do you know something
> different?

Tom has mentioned the possibility of using bitmaps as a an intermadiate
step, this would make star joins much faster as we could AND all index
info and actually examine onlu tuples that mach all indexes.

None of it is done by now, AFAIK.

-------
Hannu


В списке pgsql-performance по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Index/Foreign Key Question
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: go for a script! / ex: PostgreSQL vs. MySQL