Hiltibidal, Robert wrote:
Keep in mind that 2/3 of the inserts are actual log entries. 1/3 are for
supporting information like ip, query string values etc.
The table is a "star" table.
You are correct tho in terms of time.. When I did the same application
with fpc pascal (http://www.freepasca
Hiltibidal, Robert wrote:
Morning
I currently use DB2 on an AIX 5.2 p5 platform 7gb ram for log analytics
with heavy OLAP querying.
Index ANDing in DB2 allows for multiple indexes to be used in joins. I'm
not sure of the ORing function yet.
That's what 8.1+ support. The bitmap is in-memory th
Hiltibidal, Robert wrote:
Does postgres have support for index ANDing and index ORing?
Well, 8.1+ will create an on-the-fly bitmap for x=1 AND y=2 type of queries.
What were you thinking for ORing?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)--
Does postgres have support for index ANDing and index ORing?
Thanks!
-Rob
PRIVILEGED AND CONFIDENTIAL
This email transmission contains privileged and confidential information
intended only for the use of the individual or entity named above. If the
reader of the email is not the int
