Re: [postgis-users] statistics on a spatial index

2011-06-13 Thread José Gómez Castaño
You can use explain function to get some information from any query on
PostgreSQL

Kind regards
Jose
El 13/06/2011 15:46, "Oleksiy Karpenko" 
escribió:
> Is there any other mail list or group where I could get the answers to
> these questions?
>
> On Thu, Jun 9, 2011 at 2:08 PM, Oleksiy Karpenko
>  wrote:
>> Hi,
>>
>> How can I obtain various statistics on an existing index in the
>> database? For example, number of levels, average MBR size by each
>> dimension, and so on?
>>
>> Regards,
>> Oleksiy Karpenko
>>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] StartPGIS

2010-12-14 Thread José Gómez Castaño
I think user mannual is the best approach, it is very intuitive,
downloable from PostGIS site

You can try to use a opensource client as gvSIG and PostGIS as backend

Kind regards
Jose Gomez Castaño
ADIF

2010/12/14, Azhar Shaikh :
> Please give me guideline to start development in PostgreSQL as i am new
> comer in this.
>
> --
> Regards,
> Azhar Shaikh.
> +966550194182
>

-- 
Enviado desde mi dispositivo móvil
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[postgis-users] upgrade postgresql 8.1 to 9.0

2010-12-05 Thread José Gómez Castaño
Hi

I have PosgtgreSQL 8.1installed in a Centos 5. When I try to install Postgis
yum tell that I need to upgrade to 8.3 version at least. So I try to upgrade
it with this:

echo "exclude=postgresql* >> " /etc/yum.repos.d/CentOS-Base.repo
rpm -ivh pgdg-centos-8.3-6.noarch.rpm
yum install postgresql postgresql-server postgresql-contrib postgresql-devel

Then I try to ./configure Postgis again, but it tell the same, I need to
upgrade from 8.1 to 8.3 at least.

Someone know what is the problem?

Kind regards
José Gómez Castaño
ADIF
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users