[postgis-devel] Calling Index Genii

Paul Ramsey pramsey at opengeo.org
Fri Jan 7 07:38:29 PST 2011


No, it's still floats.

On Fri, Jan 7, 2011 at 2:31 AM, strk <strk at keybit.net> wrote:
> 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
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>



More information about the postgis-devel mailing list