On Sat, Nov 01, 2014 at 10:45:56AM -0400, Robert Burgholzer wrote: > On Saturday, November 1, 2014, Sandro Santilli <[email protected]> wrote: > > On Fri, Oct 31, 2014 at 05:12:40PM -0400, Robert Burgholzer wrote: > > > > > > GIST index does not like the bytea type. Which makes the adoption of an > > > actual geometry column even more urgent. > > > > For further accuracy, you might pass the GiST index an expression, then > > it'll like it. Example: > > > > create index on mytable using gist (geometry(mybytea)); > > explain select gid from mytable where mybytea && ST_MakeEnvelope(0,0,1,1); > > Damn right man - thanks!
NOTE: you'd still run correct selectivity estimation, unless you run the trunk version of PostGIS (to become 2.2.0), see http://trac.osgeo.org/postgis/changeset/12814 --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
