[postgis-devel] Calling Index Genii

strk strk at keybit.net
Fri Jan 7 02:31:47 PST 2011


On Thu, Dec 30, 2010 at 10:15:36PM -0800, Paul Ramsey wrote:
> Actually, testing again on the laptop (apples to apples) the speed
> different with 2D data is down to 3ms-on-new vs 1ms-on-old. When
> pulling a much larger result set (2000 records) the speed difference
> is 10ms-on-new vs 6ms-on-old. So it's closer, but still not
> equivalent.

I might be completely off-track here, but isn't the new index holding 
4 doubles rather than 4 floats ?
I remember the down-scaling of indexed boxes from HWGEOM to LWGEOM
was done for performance reasons.

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html



More information about the postgis-devel mailing list