<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Regina<div><br></div><div>I am revisiting this again. How much of a performance difference should one expect to see between the 32 bit version and the 64 bit version of postgres when using PostGIS for typical gis queries like filtering by bounding box, locating nearest points etc? Depending on how I break up my data, I'll have anywhere from 200k to 260M records per table depending on how I partition it on a machine with 32G of ram.</div><div><br></div><div>I am trying to make a case to use linux for a specific project but without being able to say there are significant gains (in performance) I'm just fighting an uphill battle. At best right now I can use the latest postgis/postgresql under windows but only 32 bit.</div><div><br></div><div>Thanks,</div><div>charles</div><div><br><div><div>On Aug 26, 2011, at 3:50 PM, Paragon Corporation wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<meta content="text/html; charset=us-ascii" http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 9.00.8112.16434">
<div style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<div dir="ltr" align="left"><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial"> > </font></span>Sadly it's for immediate
production use and I'm forced to use windows which limits my version choices a
bit given my lack of skill under windows to build postgis :(</div>
<blockquote style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px" dir="ltr">
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial"> > </font></span>charles<span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial"> </font></span></div>
<div><span class="222144519-26082011"></span> </div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial">Charles,</font></span></div>
<div><span class="222144519-26082011"></span> </div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial">You
know we do have pretty much latest builds of PostGIS (even trunk on
PostGIS website for windows).</font></span></div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial"><a href="http://www.postgis.org/download/windows/experimental.php">http://www.postgis.org/download/windows/experimental.php</a></font></span></div>
<div><span class="222144519-26082011"></span> </div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial">and
as far as PostgreSQL -- they have released windows binaries for even
PostgreSQL 9.1 RC1</font></span></div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial"><a href="http://www.enterprisedb.com/products-services-training/pgdevdownload">http://www.enterprisedb.com/products-services-training/pgdevdownload</a></font></span></div>
<div><span class="222144519-26082011"></span> </div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial">Can't get too much more current than that (all without having to
compile anything unless you are talking about the 64-bit
versions).</font></span></div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial">Thanks,</font></span></div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial">Regina</font></span></div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial"><a href="http://www.postgis.us/">http://www.postgis.us</a></font></span></div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div><span class="222144519-26082011"><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div><span class="222144519-26082011"> </span></div>
<div><font color="#0000ff" size="2" face="Arial"></font><br></div></blockquote></div>
_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></blockquote></div><br></div></body></html>