[TinyOWS-users] TinyOWS performance problem

Leukert, Boris boris.leukert at wald-und-holz.nrw.de
Thu Jun 9 11:40:19 EST 2011

I have found a workaround for the performance problem.
The trick is to create a function based index on the

CREATE INDEX parcels_digitized_the_geom_gist_trans
  ON parcels_digitized
  USING gist
  (st_transform(the_geom, 31700));

Now the query runs in 12ms with 6.3 million rows!


More information about the TinyOWS-users mailing list