[postgis-users] New 7.2 Indexing
Paul Ramsey
pramsey at refractions.net
Thu May 16 07:07:54 PDT 2002
Andy Turk wrote:
>
> > 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?
2Gb, but we use most of it to store pr0n...
More information about the postgis-users
mailing list