[postgis-users] JDBC OutofMemoryError

[Mark Cave-Ayland]

Hi Akiro,
 
When you do "select 1 from arizona_geo X, colorado_geo Y" you are actually
calculating the cross-product of the two data sets, and so the size of the
resulting data set will be equal to number of rows in arizona_geo * number
of rows in colorado_geo, which is probably why you are running out of
memory.
 
What exactly are you trying to find out from your two data tables?
 
 
Kind regards,
 
Mark.

------------------------
WebBased Ltd
17 Research Way
Tamar Science Park
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023
W: http://www.webbased.co.uk <http://www.webbased.co.uk/> 
  

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Akira
Komo
Sent: 03 August 2005 21:28
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] JDBC OutofMemoryError



Dear all,  

I have two small tables arizona_geo and colorado_geo in PostGIS 

which were converted from two shapefiles. Each of them has only 

several hundreds records. When I tried to issue a very simple query via

JDBC connection, I always got an  OutOfMemoryError. One example

query is 

    select 1 from arizona_geo X, colorado_geo Y

 I tried different postgresql JDBC driver with postgis extension, basically

 I got the same error. I am very appreciated if somebody can give me an 

idea to solve this problem.

-- Kumo

 

 


-- 

___________________________________________________________
Sign-up for Ads Free at Mail.com
http://www.mail.com/?sr=signup
<http://mail01.mail.com/scripts/payment/adtracking.cgi?bannercode=adsfreejum
p01> 

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