data mart indexing support? - Mailing list pgsql-general

From amy cheng
Subject data mart indexing support?
Date
Msg-id 19990923135802.21833.qmail@hotmail.com
Whole thread Raw
List pgsql-general
greetings, all experts & newbies there!!!

my questions are all related with data warehouse indexing:

1) does PG support bitmap index?
2) can PG use multiple indices with in ONE query? so that we do not
   need to make multiple attribute indices (composite indices).
3) can PG actually do Cartesian product on multiple relatively small
   tables ("dimension tables" in data warehouse jargon) first and
   THEN join the result with the largest table ("fact table")?


thanks!!!


amy

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

pgsql-general by date:

Previous
From: ghoffman@ucsd.edu (Gary Hoffman)
Date:
Subject: Re: [GENERAL] List of all PostgreSQL functions
Next
From: "Michal A. Kowalski"
Date:
Subject: Change table structure.