[postgis-devel] Regression performance.
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:
> 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