Re: [postgis-users] statistics on a spatial index
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
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
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