[postgis-users] OT Understanding slow queries

[Charles Galpin]

Hi Regina

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.

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.

Thanks,
charles

On Aug 26, 2011, at 3:50 PM, Paragon Corporation wrote:

>  >  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 :(
>  >  charles 
>  
> Charles,
>  
> You know we do have pretty much latest builds of PostGIS (even trunk on PostGIS website for windows).
> http://www.postgis.org/download/windows/experimental.php
>  
> and as far as PostgreSQL -- they have released windows binaries for even PostgreSQL 9.1 RC1
> http://www.enterprisedb.com/products-services-training/pgdevdownload
>  
> Can't get too much more current than that (all without having to compile anything unless you are talking about the 64-bit versions).
>  
> Thanks,
> Regina
> http://www.postgis.us
>  
>  
>  
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110901/f2bb1cf4/attachment.html>