Re: performace question

Hi,

2009/4/1 Paul Ramsey <pramsey <at> cleverelephant.ca>:
> You have spatial indexes on the tables I assume?

yes,

Indexes:
    "obce_pkey" PRIMARY KEY, btree (gid)
    "obce_the_geom_gist" gist (the_geom)
Check constraints:
    "enforce_dims_the_geom" CHECK (st_ndims(the_geom) = 2)
    "enforce_geotype_the_geom" CHECK (geometrytype(the_geom) =
'MULTIPOLYGON'::text OR the_geom IS NULL)
    "enforce_srid_the_geom" CHECK (st_srid(the_geom) = 102067)

Martin

--

-- 
Martin Landa <landa.martin gmail.com> * http://gama.fsv.cvut.cz/~landa