[postgis-users] How to improve the performance in GIS functions

[Jose Gomez-Dans]

Hi Andreas,

On 8/9/07, Andreas Laggner <bloediandi at web.de> wrote:
> I have to improve the performance from PostGis: LK Gifhorn takes 19
> seconds in ArcGis and 6 Minutes with PostGis. The intersection InVeKos
> with Atkis all over lower saxony (niedersachsen) runs since 14 hours
> now!!! That is overkill. Does someone know how to make PostGis faster in
> GIS functions?

You should really specify more clearly what you are trying to do, and
what sort of data you're using. As a first step, creating and using
spatial indices  should give you a noticeable speed improvement. Start
here: <http://postgis.refractions.net/docs/ch03.html#id2684759>.

Good luck!
Jose