From: | momjian(at)postgresql(dot)org (Bruce Momjian) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Remove item: < * Allow star join optimizations < < While our |
Date: | 2005-12-17 19:03:24 |
Message-ID: | 20051217190324.C6C479DC992@postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Remove item:
< * Allow star join optimizations
<
< While our bitmap scan allows multiple indexes to be joined to get
< to heap rows, a star joins allows multiple dimension _tables_ to
< be joined to index into a larger main fact table. The join is
< usually performed by either creating a cartesian product of all
< the dimmension tables and doing a single join on that product or
< using subselects to create bitmaps of each dimmension table match
< and merge the bitmaps to perform the join on the fact table. Some
< of these algorithms might be patented.
Modified Files:
--------------
pgsql/doc:
TODO (r1.1733 -> r1.1734)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1733&r2=1.1734)
pgsql/doc/src/FAQ:
TODO.html (r1.238 -> r1.239)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.238&r2=1.239)
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-12-17 20:15:44 | pgsql: Update ASM comments. |
Previous Message | Bruce Momjian | 2005-12-17 18:07:01 | pgsql: Update: < * Flush cached query plans when the dependent objects |