[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