[postgis-users] slow sql queries in postgis

[Mr. Puneet Kishor]

On Jan 12, 2012, at 8:21 AM, Smith Roman wrote:

> 
> Hello Everyone !
> 
> I have a postgis table containing mangrove data with 5 fields and 950,000 records. I am accessing the table using hibernate spatial in a web gis application.  I have done the following optimizations:
> 
> - Ran vacuum analyze.
> 
> - Clustering.
> 
> - Increased shared buffer from 32mb to 128mb.
> 
> 
> Inspite of this optimizations, the sql queries accessing the mangrove data are very slow.


You would have to give more details on the query... certain queries may be slow no matter what you do, while others could be sped up.

Do you have proper indexes?

> 
> I will like to ask what could be the performance problem ?
> 
> My server specs are as follows:
> 
> Processor speed: 1.87ghz. 
> Processor type: Intel Xenon.
> RAM: 2GB.
> 


RAM is way too low. Heck, even a modern word-processing program (whereby "modern" I mean feature-bloated) will run sluggish in 2 GB RAM. What is the operating system on your machine?



> 
> Are this specs good enough ?
> 
> Cheers,
> 
> 
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users