[postgis-users] slow sql queries in postgis

[Smith Roman]

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.

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.


Are this specs good enough ?

Cheers,