Re: Index/Foreign Key Question - Mailing list pgsql-performance

From Hannu Krosing
Subject Re: Index/Foreign Key Question
Date
Msg-id 1065987564.15342.2.camel@fuji.krosing.net
Whole thread Raw
In response to Re: Index/Foreign Key Question  (Andrew Sullivan <andrew@libertyrms.info>)
List 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 by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Index/Foreign Key Question
Next
From: Josh Berkus
Date:
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL