[postgis-users] postgis so slow-help
hello, i am using mapserver for windows (ms4w) ,postgres9.0,postgis2.0 and pmapper template after i successed to add one raster layer,the website become so slow how to solve this problem while i want to add more raster layers? thanks ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Postgis Installation Error
Hi Jorge, Thanx for your reply. I have tried what you said, this time its somewhat better than previous but still some problem, When I make check I am getting unning tests loader/Point.. ok loader/PointM.. ok loader/PointZ.. ok loader/MultiPoint.. ok loader/MultiPointM.. ok loader/MultiPointZ.. ok loader/Arc.. ok loader/ArcM.. ok loader/ArcZ.. ok loader/Polygon.. ok loader/PolygonM.. ok loader/PolygonZ.. ok regress. ok regress_index. ok regress_index_nulls. ok lwgeom_regress. ok regress_lrs. ok removepoint. ok setpoint. ok simplify. ok snaptogrid. ok affine. ok wkt. ok measures. ok long_xact. ok ctors. ok sql-mm-serialize. ok sql-mm-circularstring. ok sql-mm-compoundcurve. ok sql-mm-curvepoly. ok sql-mm-general. ok sql-mm-multicurve. ok sql-mm-multisurface. ok geojson. ok gml. ok svg. ok kml. ok in_gml. ok in_kml. ok regress_ogc. ok regress_ogc_cover. ok regress_ogc_prep. ok regress_bdpoly. ok regress_proj. ok dumppoints. ok wmsservers. ok tickets. failed (diff expected obtained: /tmp/pgis_reg_6910/test_47_diff) regress_buffer_params. ok hausdorff. ok Run tests: 49 Failed: 1 make[1]: Leaving directory `/sources/postgis/postgis-1.5.0SVN/regress' And getting the same error when I try to create template_postgis db. -- View this message in context: http://old.nabble.com/Postgis-Installation-Error-tp31336778p31346600.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Strange problem building postgis 1.4.2 with geos
I'm probably missing something simple. However I've been looking at this for a few hours scratching my head. First of, I know it's old versions we're using, I'm hoping to upgrade everything to the latest but We're trying to upgrade a version of geos, so we built and installed the next version of geos. geos-config --version reports 3.1.1. Ok, so far, running configure: PostGIS is now configured for x86_64-unknown-linux-gnu -- Compiler Info - C compiler: gcc -g -O2 C++ compiler: g++ -g -O2 -- Dependencies -- GEOS config: /usr/local/bin/geos-config GEOS version: 3.1 PostgreSQL config:/usr/local/pgsql/bin/pg_config PostgreSQL version: 8.2 PROJ4 version:46 PostGIS debug level: 0 All looks good, so we build ... PostGIS was built successfully. Ready to install. Now to check .. ldd postgis/libpostgis-1.4.so libgeos_c.so.1 => /usr/local/pgsql/lib/libgeos_c.so.1 (0x2b90d7544000) libproj.so.0 => /usr/local/pgsql/lib/libproj.so.0 (0x2b90d7651000) libc.so.6 => /lib64/libc.so.6 (0x2b90d77d8000) libgeos-3.0.0rc4.so => /usr/local/lib/libgeos-3.0.0rc4.so(0x2b90d7a09000) libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x2b90d7c4f000) libm.so.6 => /lib64/libm.so.6 (0x2b90d7e5) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x2b90d7fa6000) /lib64/ld-linux-x86-64.so.2 (0x4000) So, do we have a dependency on libgeos-3.0.0rc4.so? It should be libgeos-3.1.1.so lrwxrwxrwx 1 root root 23 Apr 7 12:01 /usr/local/lib/ libgeos-3.0.0rc4.so -> libgeos-3.0.0rc4.so.OLD -rwxr-xr-x 1 root root 13012533 Sep 26 2007 /usr/local/lib/libgeos-3.0.0rc4.so.OLD lrwxrwxrwx 1 root root 20 Apr 7 12:01 /usr/local/lib/libgeos-3.0.3.so-> libgeos-3.0.3.so.OLD -rwxr-xr-x 1 root root 13253940 Jan 30 2009 /usr/local/lib/libgeos-3.0.3.so.OLD -rwxr-xr-x 1 root root 14585052 Apr 7 12:13 /usr/local/lib/libgeos-3.1.1.so -rw-r--r-- 1 root root 38960654 Apr 7 12:13 /usr/local/lib/libgeos.a -rwxr-xr-x 1 root root 824 Apr 7 12:13 /usr/local/lib/libgeos.la lrwxrwxrwx 1 root root 16 Apr 7 12:13 /usr/local/lib/libgeos.so -> libgeos-3.1.1.so -rw-r--r-- 1 root root 866344 Apr 7 12:13 /usr/local/lib/libgeos_c.a -rwxr-xr-x 1 root root 856 Apr 7 12:13 /usr/local/lib/libgeos_c.la lrwxrwxrwx 1 root root 18 Apr 7 12:13 /usr/local/lib/libgeos_c.so -> libgeos_c.so.1.6.0 lrwxrwxrwx 1 root root 18 Apr 7 12:13 /usr/local/lib/libgeos_c.so.1 -> libgeos_c.so.1.6.0 -rwxr-xr-x 1 root root 277201 Sep 26 2007 /usr/local/lib/libgeos_c.so.1.3.3 -rwxr-xr-x 1 root root 321896 Jan 30 2009 /usr/local/lib/libgeos_c.so.1.4.2 -rwxr-xr-x 1 root root 448459 Apr 7 12:13 /usr/local/lib/libgeos_c.so.1.6.0 It's probably not a postgis issue per se and more of a linux build / configuration but I'd appreciate your help! Thanks - Bryan. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] (no subject)
Hi,
I suggest you try "double precision" instead of "numeric".
From Java perspective, "double precision" is a double whilst "numeric"
is a BigDecimal, which consumes much more memory and network bandwidth
than double. You could also consider "real" instead of "double
precision", which maps to Java floats, if you don't need much accuracy.
http://www.postgresql.org/docs/8.4/static/datatype-numeric.html
I hope it helps
Cheers :)
Richard Gomes
http://www.jquantlib.org/index.php/User:RichardGomes
twitter: frgomes
JQuantLib is a library for Quantitative Finance written in Java.
http://www.jquantlib.com/
twitter: jquantlib
On 07/04/11 17:57, Paul & Caroline Lewis wrote:
DB SIZE PROBLEM:
I have run the following tests on a Postgresql 9 with postgis 1.5
platform and am getting significant table and index size differences.
TestSet1 is run with a file tunnel6.asc, a CSV file with the following
being a sample of the data:
-6.34223029,53.39211958,132.586
The file is 6 GB in size with 70 million rows. After running TestSet1
the table has the correct number of rows (70 mill), random viewing of
the data and it seems fine, while the table size is 16 GB and the
index size is 6195 MB.
I now Drop Cascade the tunnel6 table for TestSet2
For TestSet2 it is run on a preprocessed version of tunnel6.asc, now
called tunnel6_py.asc, with the following being a sample of the data:
-6.34223029,53.39211958,132.586,SRID=4326;POINT(-6.34223029
53.39211958 132.586)
This file grows to 8 GB and still has 70 million rows but after
following TestSet2 steps while the table still has the correct number
of rows (70 mill), random viewing of the data and it still seems fine
but now the table size is 9.5 GB and the index size is 3363 MB.
Have I done something significantly wrong in these tests?
The TestSet2 process loads the data about 10 minutes quicker than
TestSet1 so I would like to use it but I don't trust it now given the
significant differences in table sizes.
--/
--TestSet1
--/
CREATE TABLE tunnel6
(
latitude numeric,
longitude numeric,
altitude numeric);
COPY tunnel6 (
latitude,
longitude,
altitude,)
FROM '/media/storage/tunnel6.asc'
CSV
HEADER;
SELECT AddGeometryColumn('tunnel6','wgs_geom','4326','POINT',3);
UPDATE tunnel6 SET wgs_geom = ST_SETSRID(ST_MAKEPOINT(longitude,
latitude, altitude),4326);
CREATE INDEX tunnel6_wgs_point ON tunnel6 USING gist(wgs_geom);
--/
--TestSet2 - Python PreProcessed Input File
--/
--/
CREATE TABLE tunnel6
(
latitude numeric,
longitude numeric,
altitude numeric
);
SELECT AddGeometryColumn('tunnel6','wgs_geom','4326','POINT',3);
COPY tunnel6(
latitude,
longitude,
altitude,
wgs_geom)
FROM '/media/storage/tunnel6_py.asc'
CSV
HEADER;
CREATE INDEX tunnel6_wgs_point ON tunnel6 USING gist(wgs_geom);
--/
Any help or insights would be much appreciated.
Thanks.
___
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
[postgis-users] (no subject)
DB SIZE PROBLEM:
I have run the following tests on a Postgresql 9 with postgis 1.5 platform
and am getting significant table and index size differences.
TestSet1 is run with a file tunnel6.asc, a CSV file with the following being a
sample of the data:
-6.34223029,53.39211958,132.586
The file is 6 GB in size with 70 million rows. After running TestSet1 the table
has the correct number of rows (70 mill), random viewing of the data and it
seems fine, while the table size is 16 GB and the index size is 6195 MB.
I now Drop Cascade the tunnel6 table for TestSet2
For TestSet2 it is run on a preprocessed version of tunnel6.asc, now called
tunnel6_py.asc, with the following being a sample of the data:
-6.34223029,53.39211958,132.586,SRID=4326;POINT(-6.34223029 53.39211958 132.586)
This file grows to 8 GB and still has 70 million rows but after following
TestSet2 steps while the table still has the correct number of rows (70 mill),
random viewing of the data and it still seems fine but now the table size is
9.5 GB and the index size is 3363 MB.
Have I done something significantly wrong in these tests?
The TestSet2 process loads the data about 10 minutes quicker than TestSet1 so I
would like to use it but I don't trust it now given the significant differences
in table sizes.
--/
--TestSet1
--/
CREATE TABLE tunnel6
(
latitude numeric,
longitude numeric,
altitude numeric);
COPY tunnel6 (
latitude,
longitude,
altitude,)
FROM '/media/storage/tunnel6.asc'
CSV
HEADER;
SELECT AddGeometryColumn('tunnel6','wgs_geom','4326','POINT',3);
UPDATE tunnel6 SET wgs_geom = ST_SETSRID(ST_MAKEPOINT(longitude, latitude,
altitude),4326);
CREATE INDEX tunnel6_wgs_point ON tunnel6 USING gist(wgs_geom);
--/
--TestSet2 - Python PreProcessed Input File
--/
--/
CREATE TABLE tunnel6
(
latitude numeric,
longitude numeric,
altitude numeric
);
SELECT AddGeometryColumn('tunnel6','wgs_geom','4326','POINT',3);
COPY tunnel6(
latitude,
longitude,
altitude,
wgs_geom)
FROM '/media/storage/tunnel6_py.asc'
CSV
HEADER;
CREATE INDEX tunnel6_wgs_point ON tunnel6 USING gist(wgs_geom);
--/
Any help or insights would be much appreciated.
Thanks. ___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] add a rank to population statistics- is this a case for a sequence?
Robert Buckley yahoo.com> writes: > > Hi,I have a table containing population statistics.I would like to have an column which automatically updates the rank for each dataset. Would I somehow use a sequence to calculate this, or is there another way to do this?thanks,Rob Off the top of my head, I would build a trigger that updates the rank on any insert/ update/ delete, and I would use a "window function" [1] to determine the new rankings. A sequence just keeps incrementing dumbly, so it wouldn't be a good calculating thing. [1] http://www.postgresql.org/docs/current/static/tutorial-window.html > > ___ > 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] add a rank to population statistics- is this a case for a sequence?
Perhaps use a row_number function in combination with an update trigger? http://www.postgresql.org/docs/8.4/interactive/functions-window.html Of course, you could just use the row_number function as part of a view when getting the data out rather than storing it. Mark On Thu, Apr 7, 2011 at 3:48 AM, Robert Buckley wrote: > Hi, > > I have a table containing population statistics. > > I would like to have an column which automatically updates the rank for > each dataset. Would I somehow use a sequence to calculate this, or is there > another way to do this? > > thanks, > > Rob > > > ___ > 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
[postgis-users] add a rank to population statistics- is this a case for a sequence?
Hi, I have a table containing population statistics. I would like to have an column which automatically updates the rank for each dataset. Would I somehow use a sequence to calculate this, or is there another way to do this? thanks, Rob___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] [Annouce] GISVM Base
On Thu, Apr 7, 2011 at 2:44 AM, Ricardo Pinho wrote:
> Dear all,
> We are proud to announce the new “GISVM BASE”.
> Available now for FREE DOWNLOAD at: http://gisvm.com
>
> GISVM ("GIS Virtual Machine") is a Ubuntu Linux distribution for GIS users,
> packaged as a virtual machine, a completely isolated computer that can be
> run in a window inside your current operating system.
>
> This new BASE edition, based on a minimum Ubuntu 10.10 installation,
> provides the user with simple Double Click install scripts for an unlimited
> possible number of open-source GIS packages.This way, users are FREE to
> build their own GISVM by installing the desired GIS packages.
>
> By the time of this announcement these are the available install scripts:
> - Quantum GIS / Grass
> - uDIG
> - gvSIG
> - OpenJump
> - Kosmo
> - R
> - GeoServer
> - GeoMajas
>
> We plan to keep adding more install scripts, depending on the users feedback
> and request.
>
> PLEASE REGISTER ON THE GISVM USER MAILLING LIST and help us improve this new
> version: https://lists.sourceforge.net/lists/listinfo/gisvm-users
>
> We would also appreciate it if you SPREAD THE WORD. Put it in your blog,
> forum, facebook, twitter, webpage, and so on.
>
> Thank you,
> Ricardo Pinho
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
Hi Ricardo,
That sounds really great! I was working in a VM like that, executed in
an Amazon EC2 microinstance (free tier). Now, I think I can try a kind
of "VMWare to AMI" process, using your GISVM. Maybe adding PostGIS
Raster too.
That could help:
http://thewebfellas.com/blog/2008/9/1/creating-an-new-ec2-ami-from-within-vmware-or-from-vmdk-files
Many thanks! I'll publish your work in my blog, and I'll tweet it.
--
Jorge Arévalo
Internet & Mobilty Division, DEIMOS
jorge.arev...@deimos-space.com
http://es.linkedin.com/in/jorgearevalo80
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
