<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16434"></HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=337383223-01092011><FONT color=#0000ff
size=2 face=Arial>Charles,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=337383223-01092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=337383223-01092011><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 class=337383223-01092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=337383223-01092011><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 class=337383223-01092011><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 class=337383223-01092011><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 class=337383223-01092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=337383223-01092011><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 class=337383223-01092011><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 class=337383223-01092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=337383223-01092011><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 class=337383223-01092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=337383223-01092011><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=337383223-01092011><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 class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <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<BR><B>Subject:</B> Re:
[postgis-users] OT Understanding slow queries<BR></FONT><BR></DIV>
<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
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<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></BLOCKQUOTE></BODY></HTML>