Thread: Index Anding
<div class="Section1"><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Times New Roman" size="3"><spanstyle="font-size:12.0pt;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">Good Morning</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">I am considering postgres for a project I am currently using DB2 for. </span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">The database is a 200 gb database on db2. The os is AIX 5.2 on a p5 series box with2 processors and 7 gb ram. I have 300 gb in local scsi mirrored and 300 gb of shark disk raid5. </span></font><p class="MsoNormal"><fontcolor="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">The database is primarily an olap database we use for log analytics. DB2 does not seemto be olap friendly. </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">My questions are:</span></font><p class="MsoNormal" style="margin-left:.5in"><font color="navy"face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">Does postgres provide for indexanding? </span></font><p class="MsoNormal" style="margin-left:.5in"><font color="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">InDB2 index anding is set up using a runstats command. If postgresallows index anding is index anding set up with a similar runstats command?</span></font><p class="MsoNormal" style="margin-left:.5in"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font color="navy"face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">How does postgres handle tablespaces?I currently have my indexes going to one table space with my data going to a different table space. Is this possiblein postgres?</span></font><p class="MsoNormal" style="margin-left:.5in"><font color="navy" face="Arial" size="2"><spanstyle="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal" style="margin-left:.5in"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">Doespostgres provide 64 bit support? If so is there a precompiled 64bit version for AIX? I have the 32 bit GCC and can compile 32 bit. 64 bit GCC I have not gotten stabilized. (I cold usea tip in that direction if anyone lese has experienced similar issues) </span></font><p class="MsoNormal"><font color="navy"face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">Those are the three big ones. I’ll hold off on the other questions for now.</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">Thanks!</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:navy">-Rob</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font></div><p><pre wrap="wrap">PRIVILEGED AND CONFIDENTIAL This email transmission contains privileged and confidential information intended only for the use of the individual or entitynamed above. If the reader of the email is not the intended recipient or the employee or agent responsible for deliveringit to the intended recipient, you are hereby notified that any use, dissemination or copying of this email transmissionis strictly prohibited by the sender. If you have received this transmission in error, please delete the emailand immediately notify the sender via the email return address or mailto:postmaster@argushealth.com. Thank you. </pre>
I will investigate this. Our gcc is only able to compile 32 bit. I think I will have to see if I can get/compile a 64 bit gcc I appreciate the help! -R -----Original Message----- From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Chris Browne Sent: Thursday, February 01, 2007 4:45 PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] Index Anding ajs@crankycanuck.ca (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 experienced similar issues) > > I know we've managed to get it to work using gcc, but I haven't had > to do it in a while (ask on -general or -admin, I suggest). More > important is to make sure you tell the compiler to use all the > memory. For reasons that are completely beyond my ken, AIX imposes > a memory limitation on every program at compile time. There are > some hints about this in the FAQ_AIX. Here's the environment data submitted to ./configure for a recent build of 8.1.5: pgdba@ydb1 $ ./pg_config --configure '--prefix=/where/I/stow/it '--enable-thread-safety' '--enable-debug' '--with-libraries=/opt/freeware/lib' '--with-includes=/opt/freeware/include' 'CC=gcc -maix64' 'LDFLAGS=-Wl,-bmaxdata:0x80000000,-bbigtoc' Note that you also need to export: export OBJECT_MODE=64 And you need to make sure that you are using the AIX ld, and not GNU ld... For version 7.4, it was considerably fiddlier to do a build. For 8.2, it is neither overly baroque nor overly unpleasant, which I consider a direct result of the combination of Seneca Cunningham's reports to -hackers/-ports as well as BuildFarm runs... -- (reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc")) http://cbbrowne.com/info/finances.html Rules of the Evil Overlord #30. "All bumbling conjurers, clumsy squires, no-talent bards, and cowardly thieves in the land will be preemptively put to death. My foes will surely give up and abandon their quest if they have no source of comic relief." <http://www.eviloverlord.com/> ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq PRIVILEGED AND CONFIDENTIAL This email transmission contains privileged and confidential information intended only for the use of the individual or entitynamed above. If the reader of the email is not the intended recipient or the employee or agent responsible for deliveringit to the intended recipient, you are hereby notified that any use, dissemination or copying of this email transmissionis strictly prohibited by the sender. If you have received this transmission in error, please delete the emailand immediately notify the sender via the email return address or mailto:postmaster@argushealth.com. Thank you.