| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
| Cc: | PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Index/Foreign Key Question |
| Date: | 2003-10-12 19:39:25 |
| Message-ID: | 1065987564.15342.2.camel@fuji.krosing.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2003-10-12 20:26:41 | Re: CREATE INDEX question (how to index on "money" field?) |
| Previous Message | Andrew Sullivan | 2003-10-12 19:34:48 | Re: Redhat RPMs (Was: Debian experimental packages |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-10-12 20:30:45 | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Previous Message | Andrew Sullivan | 2003-10-12 19:28:27 | Re: Index/Foreign Key Question |