[postgis-users] Difference between "Geometry" and "BLOB" in Postgis

[Sandro Santilli]

On Sat, Nov 01, 2014 at 10:45:56AM -0400, Robert Burgholzer wrote:
> On Saturday, November 1, 2014, Sandro Santilli <strk at keybit.net> 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