32 bit Windows is actually limited to 2 GB processes, or 3 GB if you start Windows with a special <b>/3GB</b> option.<div><br></div><div>Aren<br><br><div class="gmail_quote">On Thu, Sep 1, 2011 at 6:45 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><u></u>
<div style="word-wrap:break-word">
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Charles,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Honestly I have little idea. In theory you should fair
better with Linux, but I think it depends on the kinds of processes you run how
much better it is and how much ram you have. One advantage that Linux has
over windows (which is an advantage when running 32-bit Linux even, but more of
an advantage I think when you are running 64-bit Linux) is that you can allocate
more shared memory so processes that benefit on a lot of shared memory should
benefit (basically processes where you are using more or less the same data in
different ways can live in RAM. Windows is limited not just for the 32-bit
but also the 64-bit and I think this is just a fundamental flaw in PostgreSQL on
windows.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">So generally speaking on windows I can't boost my shared
memory more than say I think about 700 - 1GB without running into crashing
issues.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">As far as work mem and so forth is concerned, on 32-bit
windows you can have as much as 4GB per postgres process (and more with 64-bit
windows) , but of course if you are running </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Linux and 64-bit at that you can go up way
more.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">I'm sure Linux folks will shoot me for saying this and chew me
out, but I haven't really noticed much of a difference running my processes on
64-bit Linux vs. 32-bit window,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">but then again my processes are probably different from other
peoples and I don't have a 32G ram Linux to take advantage of the massive more
shared memory I can allocate.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">So on the low end (say 4-8GB ram range I suspect there isn't
much of a difference, but when you get higher to the 32GB/64GB range, you would
probably do a lot better with Linux.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Thanks,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Regina</font></span></div><br>
<blockquote style="border-left:#0000ff 2px solid;padding-left:5px;margin-left:5px;margin-right:0px" dir="ltr">
<div dir="ltr" lang="en-us" align="left">
<hr>
<font size="2" face="Tahoma"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>Charles Galpin<br><b>Sent:</b> Thursday, September 01, 2011 3:10
PM<br><b>To:</b> PostGIS Users Discussion<div class="im"><br><b>Subject:</b> Re:
[postgis-users] OT Understanding slow queries<br></div></font><br></div><div><div></div><div class="h5">
<div></div>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>
<blockquote type="cite">
<div style="word-wrap:break-word">
<div dir="ltr" align="left"><span><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><font color="#0000ff" size="2" face="Arial"> > </font></span>charles<span><font color="#0000ff" size="2" face="Arial"> </font></span></div>
<div><span></span> </div>
<div><span><font color="#0000ff" size="2" face="Arial">Charles,</font></span></div>
<div><span></span> </div>
<div><span><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><font color="#0000ff" size="2" face="Arial"><a href="http://www.postgis.org/download/windows/experimental.php" target="_blank">http://www.postgis.org/download/windows/experimental.php</a></font></span></div>
<div><span></span> </div>
<div><span><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><font color="#0000ff" size="2" face="Arial"><a href="http://www.enterprisedb.com/products-services-training/pgdevdownload" target="_blank">http://www.enterprisedb.com/products-services-training/pgdevdownload</a></font></span></div>
<div><span></span> </div>
<div><span><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><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" size="2" face="Arial">Thanks,</font></span></div>
<div><span><font color="#0000ff" size="2" face="Arial">Regina</font></span></div>
<div><span><font color="#0000ff" size="2" face="Arial"><a href="http://www.postgis.us/" target="_blank">http://www.postgis.us</a></font></span></div>
<div><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div><span></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" target="_blank">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br></div></div></div></blockquote></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>