[postgis-users] Query performanace against huge point table

[Santosh Gaikwad]

Hi,

 

I have a point table which contains 300 millions of records. I am using
following query to fetch the records from the table within certain
radius. 

 

Select *

   from table

   where

     st_dwithin(

       transform(the_geom,2163),

       transform(GeomFromText('POINT(-122.0527 37.323)',4326),2163),

       1000

     );

 

But it takes long time to get the result. I am seeking help.

 

Thanks & Regards,

 

Santosh Gaikwad

Senior Software Developer

Saama Technologies (India) Pvt. Ltd.,
Unit No.101-102, First floor,
Weikfield IT CITI INFO PARK, 
Weikfield estates, 
Pune Nagar Road,
Pune - 411 014. India
Phone : +91 20 66071397

Mobile: +91-9422005927
E-mail :Santosh.Gaikwad at saama.com

http://www.saama.com <http://www.saama.com> 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071120/4cd518c7/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Santosh Gaikwad.vcf
Type: text/x-vcard
Size: 145 bytes
Desc: Santosh Gaikwad.vcf
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071120/4cd518c7/attachment.vcf>