[postgis-users] Where does Postgres end and PostGIS begin?

[Ragi Burhum]

Brent and Sean are correct. Nevertheless, it is worth noting that if you are
trying to do k nearest neighbor queries, PostgreSQL 9.1 has  much better (as
in orders of magnitude) indexing support for this particular scenario. See
http://www.depesz.com/index.php/2010/12/11/waiting-for-9-1-knngist/

Of course, AFAIK, PostGIS will eventually support the knngist indexing
scheme in the future.

- Ragi



> Date: Sat, 23 Jul 2011 13:49:50 -0700 (PDT)
> From: Brent Wood <pcreso at pcreso.com>
> Subject: Re: [postgis-users] Where does Postgres end and PostGIS
>        begin?
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID:
>        <1311454190.80566.YahooMailNeo at web33201.mail.mud.yahoo.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi Patrick,
>
> The native Postgres spatial data support is primitive & of little use if
> you actually need to manage spatial data. It is non standard, & unsupported
> by virtually every mapping or analytical tool that allows you to work with
> spatial data. For most of these tools, when they say Postgres support, they
> actually mean Postgis support.
>
>
> If you do have spatial data (geometries: points, lines & polygons) to
> manage & query, you should install & use Postgis. If you don't have spatial
> data, just the usual text, numbers & maybe dates & times, you just need
> Postgres.
>
> Cheers,
>
> ?Brent Wood
>
>
>
> ________________________________
> From: Patrick Gostovic <pg at phranq.com>
> To: postgis-users at postgis.refractions.net
> Sent: Sunday, July 24, 2011 2:50 AM
> Subject: [postgis-users] Where does Postgres end and PostGIS begin?
>
> Hi.
>
> I've installed the postgresql 9.0 macports package and it seems like I have
> some spatial features already without explicitly installing PostGIS; I
> created a table with column of type POINT.? I've noticed that macports does
> have a postgis package.? Do I actually need it?? I guess I'm just really
> fuzzy as to exactly what PostGIS is relative to Postgres.
>
> Any info would be appreciated.? Thanks!
>
> Patrick
> _______________________________________________
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110725/1d21d7a2/attachment.html>