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>