Re: [SQL] Index ANDing & Index ORing

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

Re: [SQL] Index ANDing & Index ORing

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

Re: [SQL] Index ANDing & Index ORing

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)--

Re: [SQL] Index Anding

PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] Index Anding [EMAIL PROTECTED] (Andrew Sullivan) writes: >> Does postgres provide 64 bit support? If so is there a precompiled 64 >> bit version for AIX? I have the 32 bit GCC and can compile 32 bit. 64 >> bit GCC I have not got

Re: [SQL] Index Anding

This is excellent information Thank you! -Original Message- From: Andrew Sullivan [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 9:53 AM To: Hiltibidal, Robert; pgsql-sql@postgresql.org Subject: Re: Index Anding You probably want to take these questions to the -general list

[SQL] Index Anding

Good Morning I am considering postgres for a project I am currently using DB2 for. The database is a 200 gb database on db2. The os is AIX 5.2 on a p5 series box with 2 processors and 7 gb ram. I have 300 gb in local scsi mirrored and 300 gb of shark disk raid5. The database

[SQL] Index ANDing & Index ORing

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

Re: [SQL] Index Anding

[EMAIL PROTECTED] (Andrew Sullivan) writes: >> Does postgres provide 64 bit support? If so is there a precompiled 64 >> bit version for AIX? I have the 32 bit GCC and can compile 32 bit. 64 >> bit GCC I have not gotten stabilized. (I cold use a tip in that >> direction if anyone lese has experience

Re: [SQL] Index Anding

You probably want to take these questions to the -general list, or -admin, in future. That said. . . On Wed, Jan 31, 2007 at 08:56:21AM -0600, Hiltibidal, Robert wrote: > > Does postgres provide for index anding? Yes. See .