[postgis-devel] ST_Value performance
Sandro Santilli
strk at keybit.net
Tue Jan 31 12:11:16 PST 2012
On Tue, Jan 31, 2012 at 02:52:26PM -0500, Pierre Racine wrote:
> I better see your point now. Must be the update itself that takes long, not the ST_Value().
I don't have the original table with me anymore as I re-imported it
as tiled. I suspect the problem was with && operator and a lack of spatial
index on one of the two sides. It's pretty quick with the 1x1 version :)
--strk;
,------o-.
| __/ | Thank you for PostGIS-2.0 Topology !
| / 2.0 | http://www.pledgebank.com/postgistopology
`-o------'
More information about the postgis-devel
mailing list