[postgis-users] need better performance

[vollbotz]

Hallo,
i would like to use the following sql statement:

create table einzellagen.alk_kombi as
SELECT  g.oid, g.code, b.wlg_nr, b.wlg_name,
AREA (Intersection ( g.the_geom, b.the_geom )) as f_alk_teilfläche,
AREA (g.the_geom) as f_alk_gesamt,
g.the_geom
FROM  alk.v_al001 AS g, einzellagen.el_alle AS b
where INTERSECTION ( g.the_geom, b.the_geom ) = TRUE;

> it should calculate the area of intersecting geometries
>> syntax is ok
>> number of Geometries:   6.500.000  zu 2000

Problem:  Quest need a few day - and then i stop with no result....
>> In ArcMap it works within hours....

Is there something i could change to get a better performance (hardware is
ok)  ??

Thanks / Greets

-- 
View this message in context: http://old.nabble.com/need-better-performance-tp27517322p27517322.html
Sent from the PostGIS - User mailing list archive at Nabble.com.