[postgis-users] slow sql queries in postgis

Nicolas Ribot nicolas.ribot at gmail.com
Thu Jan 12 08:11:37 PST 2012


Hi,

What are the PostgreSQL/Postgis versions ?

Nicolas

On 12 January 2012 15:40, Mr. Puneet Kishor <punk.kish at gmail.com> wrote:
>
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list