[postgis-users] New 7.2 Indexing

Andy Turk andy at streetlight.com
Wed May 15 17:24:47 PDT 2002


> Creating an index on 801021 rows takes 2 minutes 40 seconds on 7.1 with the
> old indexing, and 1 minute 19 seconds with the new indexing for 7.2. This
> is on a pretty fast machine (Dual Athlon 1.6GHz) - the results might be
> more dramatic on a slower or busier server.

How much memory in that dual box?




More information about the postgis-users mailing list