[postgis-users] Fun with GiST and Postgis

[Paul Ramsey]

Andy Turk wrote:

> The resulting table is a little north of 31 million rows. It took 5 hours to 
> create a geometry index on our 500 MHz Xeon server. To be honest, it was a 
> nerve wracking 5 hours because I didn't know whether to expect it to take 
> linearlly longer than my previous 2M row dataset, or quadratically longer. I 
> was also concerned that something might break with an index that size. But it 
> seems to work just fine.

Which was it, linear or quadratic? If you are using 0.7.X, it should 
hopefully be linearish.

> Queries using the index are pretty snappy although we haven't really started 
> pushing Postgres' buffer cache yet. This machine has 4G of RAM with 1G 
> allocated to shared buffers.

Nice!

> Heh. How much would an Oracle license would be for a 4 CPU server with Oracle 
> Spatial tacked on for good measure? ;-)

I shudder to think. Particularly if you're doing a web app!


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_