[postgis-devel] Regression performance.

Sandro Santilli strk at keybit.net
Mon Feb 13 07:30:01 PST 2012

On Mon, Feb 13, 2012 at 10:25:18AM -0500, David Zwarg wrote:
> Pierre,
> +1
> As for the penalty, you are correct: the penalty appears to be caused by
> casting the integers to float values in the expression.

Ok, in this case keeping it INT (not FLOAT) won't make anyone _not_
using [rast.x] or [rast.y] incur in any penalty and give the correct
type for the others. Those using [rast.x] and [rast.y] in floating
point arithmetics will have to live with the performance issue while
those using them as INTegers will be fine.


  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net

More information about the postgis-devel mailing list