This is R-Tree implementation using GiST for spherical objects

This isanR-Tree implementation using GiST for spherical objects

like spherical points and spherical circles with

useful functions and operators.

NOTICE:

This version willworks only with postgresql version8.0 and above.

This version willwork only with postgresql version9.1 and above.

INSTALLATION:

gmake install

--load functions

psql<database> <pg_sphere.sql

make USE_PGXS=1 install

--add the psSphere extension to a database

psql-c 'CREATE EXTENSIONpg_sphere;' <database>

REGRESSION TEST:

REGRESSION TEST (as the same user as the currently running postgresql server):

gmake installcheck

make USE_PGXS=1 installcheck

LONG REGRESSION TEST:

gmake crushtest

make USE_PGXS=1 crushtest

For more informations have a look at http://pgsphere.projects.postgresql.org/

The 'make' program must be compatible with GNU make.

For more information, have a look at http://pgsphere.projects.postgresql.org

and https://github.com/akorotkov/pgsphere

Have a lot of fun!

<application>pgSphere</application> uses <literal>GiST</literal>

to create spherical indices. An index speeds up the execution

time of operators <link

linkend="op.over"><literal>&lt;@</literal></link>, <link

linkend="op.over"><literal>@</literal></link>, <link

linkend="op.over"><literal>&amp;&amp;</literal></link>, <link

linkend="op.cross"><literal>&num;</literal></link>, <link

linkend="op.equal"><literal>=</literal></link>, and <link

linkend="op.equal"><literal>!=</literal></link>. You can create

an index with following spherical data types:

an index withthefollowing spherical data types:

</para>

<itemizedlist>

<listitem>

<para>

<application>pgSphere</application> is not part of the <application>PostgreSQL</application> software.

You can download it from the <application>pgSphere</application> homepage

<ulink url="http://pgfoundry.org/projects/pgsphere/"><citetitle>http://pgfoundry.org/projects/pgsphere/</citetitle></ulink>

<ulink url="https://github.com/akorotkov/pgsphere"><citetitle>https://github.com/akorotkov/pgsphere</citetitle></ulink>

</para>

</sect2>

</title>

<para>

You will need <application>PostgreSQL

7.3</application> or above. We assume that you have

9.1</application> or above. We assume that you have

<application>PostgreSQL</application> already compiled and

installed. Please note: Depending on your system configuration mostly you have to be logged in as the system

superuser.

<para>

We assume you have already created a database

<database>datab</database>, where <database>datab</database>

is the name of any database. Now change into the directory

<filename>POSTGRESQL_INSTALL_PATH/share/contrib</filename>.

is the name of any database.

Presupposing the name of your

<application>PostgreSQL</application>'s superuser is

<parameter>postgres</parameter> type:

<parameter>postgres</parameter>, type:

</para>

<programlisting>

<![CDATA[shell> psql -U postgresdatab <pg_sphere.sql]]>

<![CDATA[shell> psql -U postgres-c 'CREATE EXTENSIONpg_sphere;' datab]]>

</programlisting>

<para>

Depending on your system, it may be necessary to give more

call:

</para>

<programlisting>

<![CDATA[pgsql> SELECT pg_sphere_version()]]>

<![CDATA[pgsql> SELECT pg_sphere_version();]]>

</programlisting>

</sect2>